Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Worksheet Page
Can I hide a worksheet page so it is not viewed by others but is still able
to provide data to other worksheets? If so, How and how would I unhide it when I need to view it? Thank you, V.XIII |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Worksheet Page
With the sheet selected, click on Format | Sheet then click Hide. If
you want to unhide it, click Format | Sheet | Unhide and you will be presented with a list of hidden sheets - just select the one you want. Hope this helps. Pete On Aug 31, 9:20*pm, Vercingetorix.XIII wrote: Can I hide a worksheet page so it is not viewed by others but is still able to provide data to other worksheets? If so, How and how would I unhide it when I need to view it? Thank you, V.XIII |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Worksheet Page
If you have users who might have the boldness.knowhow to unhide the sheet by
doing the Format, Sheet, Unhide,,, You should know that you can using VBA hide the sheet via it's visible property assigning it as: Sheets("Sheet2").visible = xlSheetVeryHidden ' to hide or Sheets("Sheet2").visible = xlSheetVisible ' to unhide Jim may "Pete_UK" wrote: With the sheet selected, click on Format | Sheet then click Hide. If you want to unhide it, click Format | Sheet | Unhide and you will be presented with a list of hidden sheets - just select the one you want. Hope this helps. Pete On Aug 31, 9:20 pm, Vercingetorix.XIII wrote: Can I hide a worksheet page so it is not viewed by others but is still able to provide data to other worksheets? If so, How and how would I unhide it when I need to view it? Thank you, V.XIII |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a muliple page worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
how to hide page breaks? | Excel Discussion (Misc queries) | |||
hide omit first page number | Setting up and Configuration of Excel | |||
How do I keep the header on the first page but hide it on the sec. | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |