Unhiding the worksheet

[Guest]

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

 

[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)

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.

 

[Guest]

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

Currently I am working on a project where I want to hide a particula

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