Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protection - hiding worksheets | Excel Worksheet Functions | |||
Hiding Columns in Worksheets saved in CSV Format | New Users to Excel | |||
hiding worksheets in excel | Excel Worksheet Functions | |||
Hiding Worksheets | Setting up and Configuration of Excel | |||
Conditional hiding of worksheets | Excel Discussion (Misc queries) |