stationary command button

[Jase]

I have some embedded command buttons on a sheet overlaying some hidden rows.
When I unhide the rows my command button shifts. Is their a way to make my
command button stay in the same location when i hide/unhide my rows?

 

[Jim Thomlinson]

Right click the buttons and select Format Control... (you may need to put you
spreadsheet in design mode). On the properties tab select "Don't move or size
with cells".

 

[Gord Dibben]

Format the button properties to "don't move or size with cells"


Gord Dibben MS Excel MVP