HIde control

[Monty]

Hi

I have forty worksheets within a workbook. Is there anyway that i can hide
39 which hold all the data and keep sheet one as the master. On the master i
have ceated hyperlinks to diffrent workseets within the workbook.

Any help Please.

Monty

[Nikki]

selesct all the sheets you want to hide. go to Format-->Sheet--> select Hide
to unhide go to format -->Sheet--> Unhide

"Monty" wrote:

> Hi
>
> I have forty worksheets within a workbook. Is there anyway that i can hide
> 39 which hold all the data and keep sheet one as the master. On the master i
> have ceated hyperlinks to diffrent workseets within the workbook.
>
> Any help Please.
>
> Monty

[Gord Dibben]

Monty/Nikki

Unfortunately, hidden sheets will not react to hyperlinks.

i.e. if hyperlink on Master is to Sheet34, pressing the hyperlink will not
reveal or jump to Sheet34.

If, by "hyperlinks" you mean just regular links, hiding the sheets will not
affect these.


Gord Dibben Excel MVP

On Fri, 18 Nov 2005 10:09:04 -0800, "Nikki" <Nikki@discussions.microsoft.com>
wrote:

>selesct all the sheets you want to hide. go to Format-->Sheet--> select Hide
> to unhide go to format -->Sheet--> Unhide
>
>"Monty" wrote:
>
>> Hi
>>
>> I have forty worksheets within a workbook. Is there anyway that i can hide
>> 39 which hold all the data and keep sheet one as the master. On the master i
>> have ceated hyperlinks to diffrent workseets within the workbook.
>>
>> Any help Please.
>>
>> Monty

[Nikki]

thanks so much. I didn't know.

"Gord Dibben" wrote:

> Monty/Nikki
>
> Unfortunately, hidden sheets will not react to hyperlinks.
>
> i.e. if hyperlink on Master is to Sheet34, pressing the hyperlink will not
> reveal or jump to Sheet34.
>
> If, by "hyperlinks" you mean just regular links, hiding the sheets will not
> affect these.
>
>
> Gord Dibben Excel MVP
>
> On Fri, 18 Nov 2005 10:09:04 -0800, "Nikki" <Nikki@discussions.microsoft.com>
> wrote:
>
> >selesct all the sheets you want to hide. go to Format-->Sheet--> select Hide
> > to unhide go to format -->Sheet--> Unhide
> >
> >"Monty" wrote:
> >
> >> Hi
> >>
> >> I have forty worksheets within a workbook. Is there anyway that i can hide
> >> 39 which hold all the data and keep sheet one as the master. On the master i
> >> have ceated hyperlinks to diffrent workseets within the workbook.
> >>
> >> Any help Please.
> >>
> >> Monty
>
>