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

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" wrote in message
...
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

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" wrote in messag
..
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
Than