I have a button on a worksheet that moves when I delete rows. How can I make it fixed on a page?
S Shawn Aug 30, 2005 #1 I have a button on a worksheet that moves when I delete rows. How can I make it fixed on a page?
M Mike Aug 30, 2005 #2 place the button on the top row, highlight the cell below it, click on windows - freeze pane.
E Eric Aug 30, 2005 #4 Shawn, Right-click on the button (you have to be in design mode to do this - use the Control Toolbox menu to do this, or look it up in Help), click on Format Control, click on the Properties tab, and select "Don't move or size with cells". Eric
Shawn, Right-click on the button (you have to be in design mode to do this - use the Control Toolbox menu to do this, or look it up in Help), click on Format Control, click on the Properties tab, and select "Don't move or size with cells". Eric
