ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unhiding the worksheet (https://www.excelbanter.com/excel-programming/300358-unhiding-worksheet.html)

JAY

Unhiding the worksheet
 
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[_6_]

Unhiding the worksheet
 
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




JAY

Unhiding the worksheet
 
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






All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com