Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pages
Hi...is it possible to hide some (not all) excel pages that perhaps contain
tables you don't want your staff to know? Thanks Gordon. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pages
This forum deals with MS Project scheduling software. You should repost
in an Excel forum. Gordon wrote: Hi...is it possible to hide some (not all) excel pages that perhaps contain tables you don't want your staff to know? Thanks Gordon. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pages
Dave...
Looks like excel programming from my end. Are there some wires crossed somewhere? Thanks Gordon... "davegb" wrote: This forum deals with MS Project scheduling software. You should repost in an Excel forum. Gordon wrote: Hi...is it possible to hide some (not all) excel pages that perhaps contain tables you don't want your staff to know? Thanks Gordon. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pages
Hmmmm, dont know whats going on but look you've come the right place to me.
In response to your original request you need something like: sheets("you sheet name here").visible=false or sheet1.visible=false to reverse just set it to true. "Gordon" wrote in message ... Dave... Looks like excel programming from my end. Are there some wires crossed somewhere? Thanks Gordon... "davegb" wrote: This forum deals with MS Project scheduling software. You should repost in an Excel forum. Gordon wrote: Hi...is it possible to hide some (not all) excel pages that perhaps contain tables you don't want your staff to know? Thanks Gordon. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pages
Gordon,
For Worksheets you have 3 choice for .Visible: ?xlSheetHidden 0 ?xlSheetVisible -1 ?xlSheetVeryHidden 2 As you can see, the first 2 evaluate to False & True. The user can reverse these settings in the FormatSheetHide/UnHide. However, if you use the 3rd option, the user cannot change, except by code. NickHK "Gordon" wrote in message ... Dave... Looks like excel programming from my end. Are there some wires crossed somewhere? Thanks Gordon... "davegb" wrote: This forum deals with MS Project scheduling software. You should repost in an Excel forum. Gordon wrote: Hi...is it possible to hide some (not all) excel pages that perhaps contain tables you don't want your staff to know? Thanks Gordon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
hide pages | Excel Discussion (Misc queries) | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... | Excel Worksheet Functions | |||
Hide Pages | Excel Programming | |||
How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) |