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.

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.

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

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

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