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
 

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

Top