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,