HIde control
 

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

HIde control
 

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

HIde control
 

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

HIde control
 

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