Hiding worksheets?

P

phil2006

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
 
M

Max

phil2006 said:
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?
Click to expand...

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.
 
M

Mallycat

You can't edit what you can't see. Your only real option is to hid
them when you don't want to see them, and unhide them when you do. Yo
could create a simple macro to do this for you and create a button t
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

Mat
 
Top