stationary command button
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? |
stationary command button
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? |
stationary command button
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? |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com