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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Cannot insert object' message when I try to put a button on a worksheet 7
command buttons disappear when I move worksheet 2007 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Command button moves even with don't move or resize checked. 4
Format Shape, will not move accordingly, when deleting columns 3
Command buttons linked to moving rows 2
Delete/Remove Button 9
Inserting a Graphic on a Button when the Button is Assigned to a M 2

Back
Top