LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Hiding Worksheets and Unhiding them easily for Novice User

A former student in an Excel class has asked me the following question, "My
manager has posed a Microsoft Excel question that I am unable to answer so I
thought Id reach out for your assistance. I am working on a workbook for
her that has 20 tabs (worksheets). 10 of the tabs are related to one topic,
and the other 10 tabs are related to second topic. Shed like to open the
workbook and have two taps (Topic One & Topic Two) and then click on the
respective tab to see the 10 tabs that apply to it. Is it possible to do
tabs within tabs?"

1) I put together a recording macro that seems to work OK. I recorded
several macros and assigned them to buttons and it looks like it works. It
appears that a user would have problems if worksheets were renamed and added
so I'm not sure if this is a good solution.

2) My question to the newsgroup: Is macro the way to go or is there
something else for this person?

Thanks for any assistance in coming up with alternatives for this situation!

Jugglertwo


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding & Unhiding graphs... Ray Charts and Charting in Excel 1 February 21st 07 08:37 PM
Hiding & Unhiding Cells, How to Create a calendar drop down box Excel Discussion (Misc queries) 0 January 26th 07 05:12 PM
Hiding worksheets based on user selection HL Excel Worksheet Functions 3 October 12th 06 04:01 PM
Hiding/Unhiding Columns xkarenxxxx Excel Worksheet Functions 8 June 5th 06 02:18 PM
Hiding/Unhiding Bobby Excel Worksheet Functions 2 May 25th 05 10:40 PM


All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"