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

Jim Thomlinson


"Jase" wrote:

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?

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


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 07:47:01 -0700, Jase
wrote:

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?