Software·43,882 discussions

How to make invisible Excel worksheet tab

Locked

Dear forum memebers:
I’m looking for a way how to make (secondary)worksheets tabs invisible. Not to hide the worksheets, but make their tabs not shown – I need to be able to open those worksheets only using hyperlinks from master worksheet. I just want to hide their tabs.
Please help.

Topic

Clarifications

In reply to How to make invisible Excel worksheet tab

Clarifications

Hide worksheet tabs

In reply to How to make invisible Excel worksheet tab

Hi,

I’m doing exactly the same thing. I have a “home” page with links to all the other sheets, and by forcing users to navigate via those links, I can best control the program and ensure smooth operation. I’d like to hide just the tabs (or basically hide the tabs for all sheets, but not hide the sheets themselves).

Did you ever find a way to do this?

Thanks,

Will
San Diego, CA

UPDATE 5 MINUTES LATER:

I went to my most reliable Excel VBA source, the “Discussions in Excel Programming Newsgroup” and almost immediately found this code:

ActiveWindow.DisplayWorkbookTabs = False

Which is great. I just run this in

Workbook_Open

and set it back to True in

Workbook_BeforeClose.

thx,

[Author]

Replies