View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Robl Brad Robl is offline
external usenet poster
 
Posts: 1
Default 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