PDA

View Full Version : Stop button from moving



bloomington
12-20-2014, 01:23 PM
Just a minor question. I have created a macro which involves the deletion and shifting of some columns. In the excel spreadsheet I have a button to execute the macro. The problem is that when I press the button to execute the program which involves the shifting of columns, the button also shifts as a consequence as well, since its located on the same sheet (Sheet1) where the columns are shifted. Is there a way to create a button that will not move when columns are shifted? or not be impacted by the shift? no matter where I put the button on sheet1 just the fact that columns are deleted and the remaining ones shift to the left automatically moves the button to the left as well. Thanks in advance.

ashleyuk1984
12-20-2014, 02:08 PM
Try this.

Right click on the button, and go to 'Format Control'.
Then when the formatting options come up, navigate to the 'Properties' tab.
Then check the box saying 'Don't move or size with cells'.

http://www.ultraimg.com/images/Capture2ad8e.png