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

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

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

Hi,

Right click the button, Format control, Properties tab.

Select 'Dont move or size with cells'

Mike


"CH-DE-FDS APRIL" wrote:

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

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

Thanks Mike

"CH-DE-FDS APRIL" wrote:

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