Question

Locked

How to make invisible Excel worksheet tab

By Castawaysdesign ·
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.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Hide worksheet tabs

by cyclometric In reply to How to make invisible Exc ...

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,

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums