Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a Worksheet
I need to put a multi-worksheet Excel file on a network folder so others can
read it; however, I would like to "hide" one of the worksheets. Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a Worksheet
Select the sheet that you want to hide then from the menu:
Format | Sheet | Hide But it can be unhidden using the same process. To really hide it you can get into the VB Editor and use that to set the sheet's visible property to xlVeryHidden which not only hides it but keeps it from showing up in the list of sheets available to be unhidden. "oceanmist" wrote: I need to put a multi-worksheet Excel file on a network folder so others can read it; however, I would like to "hide" one of the worksheets. Is there a way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a Worksheet
Yes,
Select the sheet Format|sheet|hide but theres nothing to stop anyone going format sheet unhide. You can do it slightly better in VBA Sub stantiate() Worksheets("Sheet1").Visible = xlVeryHidden End Sub Doing it like this you can't now simply unhide it you have to resort to VB The bottom line is while it can be done you do it because you don't want people to see something and this about the most insecure way possible of doing that. Mike "oceanmist" wrote: I need to put a multi-worksheet Excel file on a network folder so others can read it; however, I would like to "hide" one of the worksheets. Is there a way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a Worksheet
There is a way to do this effectivley without resorting to VBA.
Just do as the guys suggest (Format|Sheet|Hide) then protect the workbook with password (Tools|Protection). That way, all the Format|Sheet options will be 'greyed out' to the user, so your hidden sheet will be invisible. There may be some reason why you do not wish to do Protect Workbook course. Phil "oceanmist" wrote in message ... I need to put a multi-worksheet Excel file on a network folder so others can read it; however, I would like to "hide" one of the worksheets. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding the worksheet | Excel Discussion (Misc queries) | |||
Hiding worksheet unless selected | Excel Discussion (Misc queries) | |||
Hiding a Worksheet | Excel Worksheet Functions | |||
Hiding zeros on my worksheet | Excel Discussion (Misc queries) | |||
Hiding a worksheet while formatting it | Excel Worksheet Functions |