Unhiding the worksheet

J

JAY

Currently I am working on a project where I want to hide a particular sheet from end users but can not protect the workbook as other sheets should be seen by users. Users should not be able to see the hidden file
Thanx
 
B

Bob Phillips

Jay,

Are you asking for?

Worksheets("Sheet3").Visible = xlSheetVeryHidden

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

JAY said:
Currently I am working on a project where I want to hide a particular
Click to expand...
sheet from end users but can not protect the workbook as other sheets should
be seen by users. Users should not be able to see the hidden file.
 
J

JAY

Great it works Thanks a lo

----- Bob Phillips wrote: ----

Jay

Are you asking for

Worksheets("Sheet3").Visible = xlSheetVeryHidde

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

JAY said:
Currently I am working on a project where I want to hide a particula
Click to expand...
sheet from end users but can not protect the workbook as other sheets shoul
be seen by users. Users should not be able to see the hidden file
 
Top