Hide Command Button & Rows
Help please. I have a command button on sheet1. When pressed it has to unhide rows and command buttons on sheet2. Likewise the reverse also has to happen. At the moment, when I hide the rows, the command buttons move down to the nearest visible row. If saved here as the defauls position, they don't return to the correct position when the rows are made visible.
Please help.
When you right click on the button and Format the control. The Properties tab has various options of moving and/or sizing the button with cells. I like to have my controls do neither.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
To hide the button when the rows are hidden, add
to the hide rows routine.
Please Login or Register to view this content.
To unhide the button when the rows are unhidden is different. Unhiding rows will trigger a Calculate event if there is a formula on the sheet that refers to both hidden and unhidden cells. That's the only way I know to trigger an "UnHide" event.
This event code will unhide CommandButton 1 when Row 2 is unhidden. Some modification of it should work for you.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks