Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel forms - hiding a group of controls
I have an Excel spreadsheet with controls on the sheet. The controls have a gray label behind them so it looks like a form on top of the Excel sheet. I need to have something like a Multipage, where I can have 2 pages of information, but Multipage doesn't appear to be an option for controls that can be placed on the Excel sheet.
I thought about having command buttons that say page 1 and page 2, and they could hide or show the controls for the appropriate page, however, I don't want to have to list each control within the programming and hide each one. Is there any other way to do this? Thank you. EggHeadCafe - Software Developer Portal of Choice Dr. Dotnetsky's Cool .NET Tips and Tricks # 4 http://www.eggheadcafe.com/tutorials...-cool-net.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to code tab order for Controls in Excel forms | Excel Programming | |||
Letting users calculate Excel forms on the web while hiding the logic | Excel Discussion (Misc queries) | |||
Letting users calculate Excel forms on the web while hiding the logic | Excel Programming | |||
Group a range - closing the group does not hide the controls.... | Excel Programming | |||
Excel forms controls | Excel Discussion (Misc queries) |