Sheet Tabs hide and unhide

G

Guest

Excel 2007 does not provide a function to hide or unhide all SHEET TABS (I am
not referring to the function used to hide an individual sheet). In 2003
this was a Sheet Tabs checkbox in "Tools/options/view/window options". This
would hide/unhide sheet tabs. The equivalent cannot be found in 2007.

"Hide/unhide sheet tabs" is an important feature in many of our workbooks
where we want the user to follow a predefined process and don't want them
selecting any sheet that takes their fancy.

John


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...beff022&dg=microsoft.public.excel.crashesgpfs
 
N

Nick Hodge

John

Try Office Button>Excel Options>Advanced>Display Options for this workbook
heading and it just there

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top