Hide Pages

[Gordon]

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.

[davegb]

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.

[Gordon]

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

[Graham Whitehead]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>>
>>

[NickHK]

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 Format>Sheet>Hide/UnHide.
However, if you use the 3rd option, the user cannot change, except by code.

NickHK

"Gordon" <[email protected]> wrote in message
news:[email protected]...
> 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.
> >
> >