![]() |
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 |
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 |
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