Excel forms - hiding a group of controls

B

Brad Robl

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/tutorial...b146-89d4f30844a0/dr-dotnetskys-cool-net.aspx
 

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

Ribbon X: Macro not available 1
Consolidate CSV files with historical returns for stocks in onespreadsheet 1
excel macros 3
what should be in a security comand center 2
vendor access 1
Secondary Axis in Powerpoint graphs 2
Calendars 1
Word 2000 and Outlook 2007 conflict 1

Top