stationary command button

J

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?
 
J

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".
 
G

Gord Dibben

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


Gord Dibben MS Excel MVP
 
Top