Excel 2007: Hidden Worksheets - Accessible while hidden

[ladyck3]

If your workbook contains many worksheets and the first of which is a sort of index or table of contents of the workbook, is there a way to hide all of the worksheets (I know how to hide/unhide) so the user sees only the Contents page but the links on that page to the internal worksheets will still open the worksheet in question?

I have HOME buttons on each worksheet for ease of user control but I really would like to condense the visual tabs... so only a specific tab or some specific tabs are visible and the hidden ones can be accessed via the respective contents worksheets.

Meaning if I had 3 topics in one workbook, I can have 3 contents tabs... but the multiple tabs per topic are hidden.

Am I asking too much of my favorite application in all of the world?

I'm not a programmer in any sense of the word so I hope its a function or feature that I just don't know about "Yet".

Thank you in advance.


ladyck3
aka: Laurie

 

[SkipVought]

Hi,

Worksheets that are hidden can be unhidden using right-click on sheet tab & select Unhide... from the popup.

In code it is

 sheetobject.visible = xlsheetvisible  'make sheet visible

 sheetobject.visible = xlsheethidden  'make sheet hidden

There is also a VeryHidden state, that can only be done via VBA or the VBA editor.

Hope this helps.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ladyck3]

Hey Skip....

This code, does it allow for the links on the index page to 'work'? If I use this will the hidden pages stay hidden until they are 'requested' from a click on the index?

I wish I could do that... and when the home button was used to go back to the index, the worksheet would be hidden again.

Oh well... hiding and unhiding can be done easily enough.... I didn't think Excel could quite do what I'd like it to do

Thanks for responding....

I've got a report that is going to have 4 different parts but I didn't want 4 different files.. Just 4 tabs showing to link to the multiple data for each of the 4 parts. ARGH

What ya want and what ya get, sometimes, is 2 different things! ... I know <sigh>


ladyck3
aka: Laurie

 

[combo]

Hi,
when I prepare code-free excel application, I use hyperlink navigation between visible worksheets, but with hidden workbook tabs (up to excel 2003 can be set in tools>options>view tab, it's workbook level setting).
The user can still unhide them, but most of them use navigation buttons in the frozen pane.

combo

 

[evelynmorry]

well, maybe you can seek for help with some spplications. To meet your needs, I think an excel add-in Kutools for Excel can help. It is an excel add-ins collection to free from time consuming and repetitive excel work.

One of the function there is Excel Explorer, also see as Navigation Pane, with it you can view all your sheets in a list and quick navigate and jump to the one you want to use. Even works well when you use the Hide/Unhide function. The application also has the function of hiding selected ranges, inactive worksheets and workbooks, or a specific worksheet you want to hide in one click. When the sheets are hided, you can view the unhidden sheets in the Navigation Pane. When all the hidden sheets turn to unhidden, it can also be reflected in the pane to fast navigate.

A very neat app is.

 

[ladyck3]

Hey evelynmorry, thanks for the tip.

I'm familiar with add-ins... I live and breath using ASAP Utilities it makes my job SO MUCH EASIER.... Mostly I use it to protect/unprotect multiple pages. You can select to print multiple pages.

Import HTML Content and stuck with all the html junk? ASAP an remove all of that and you have just text.

A text to number feature that works all the time even when the numbers are text and Excel's option doesn't work. One key feature as well is removing all of the extra spaces before and after content.

But I'll check out Kutools... Thanks!!



ladyck3
aka: Laurie

 

[ladyck3]

Hey evelynmorry,

I have a problem... I'm having issues installing it on my honme pc so I tried at work and at work we're running XP. The Kutools addin now available is not compatible with XP.

I'm not asking YOU for support but do you know where verison 1.0 can be downloaded from to test?

I'm still troubleshooting on my home PC with Win7 64-bit.

Thanks!


ladyck3
aka: Laurie

 

[evelynmorry]

So sorry for the problem you meet. Actually i also had problem with the win 7 before, but now it works. The Kutools for Excel only supports Window Vista, Window 7, and is not available in Windows XP.

Hopt it can help. ~

 

[ladyck3]

I just wanted to update you on my RESOLUTION.. .yes I found one...
I use an addin called ASAP Utilities (.com) and it has that capability just by checking or unchecking a checkbox under the "VISION" menu.

My problem is solved but thanks everyone for your feedback...

Sincerely!! (Guys... I solved one all by myself!> GO ME LOL

Laurie

ladyck3
aka: Laurie