View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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