Hiding worksheets?
 

Is it possible to hide worksheets but still have them available to edit?
Or is there a way in which I could put the worksheets into a folder just
so that the bar along the bottom is less cluttered?

Thanks,


Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=561020

Hiding worksheets?
 

"phil2006" wrote:
Is it possible to hide worksheets but still have them available to edit?
Or is there a way in which I could put the worksheets into a folder just
so that the bar along the bottom is less cluttered?

If you do a right-click on the vcr-like controls at the bottom bar's left
corner (where you see the sheet tabs), you'd get a pop-up list to easily
select any visible sheet that you want to zip to.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hiding worksheets?
 

You can't edit what you can't see. Your only real option is to hide
them when you don't want to see them, and unhide them when you do. You
could create a simple macro to do this for you and create a button to
toggle them visible and invisible.

Sub ToggleVisible()
Sheets("Sheet3").Visible = Not Sheets("Sheet3").Visible
End Sub

You can repeate the line

Sheets("Sheet3").Visible = Not Sheets("Sheet3").Visible

for each sheet you want to see/not see

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561020