stationary command button

  • Thread starter Thread starter Jase
  • Start date Start date
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?
 
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".
 
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

Similar Threads

Command button unhides but not hides 1
hide/unhide macro 2
Error when trying to delete a macro... 5
command button add another command 5
password protect unhide sheet command 1
Unhide a row 1
Cannot unhide the hidden rows in my spreadsheet 3
Can't unhide rows 3

Back
Top