How to stop a Control Button moving when I delete columns(Excel)

  • Thread starter Thread starter CH-DE-FDS APRIL
  • Start date Start date
C

CH-DE-FDS APRIL

I use a file to format external data every month.
Each time I use it, the Control Button(Macro Button) moves because I delete
a number of columns.

How do I freeze the buton to a position "on screen" without it being
affected by delte /insert commands
 
Hi,

Right click the button, Format control, Properties tab.

Select 'Dont move or size with cells'

Mike
 
Back
Top