HIde control

M

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
 
N

Nikki

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

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
 
N

Nikki

thanks so much. I didn't know. :)

Gord Dibben said:
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
Click to expand...
 
Top