Passowrd on a Page in an Excel Sheet

I have a custom applciation which does an export of data in excel sheet. The excel sheet contains 5 pages (TABS) . I would like to passowrd protect one of the tab or page which contains confidential information since today, the applcation must allow any level of users to export the sheet.. Is there a way to somehow do somthing to make certain people NOT to view that page? It really does not have to be a passowrd protect as I am open to any suggention.

Thanks in advance for any comments.

Alex

Depends on how "protected" it should be.
Here's some code: http://www.mvps.org/dmcritchie/excel/hidden.htm
Try right click on the Sheet tab, select View Code then Select: Visible: 0 - xlSheetHidden.
BUT BE CAREFUL!! If you select Visible: Very hidden you can not even see that there is a hidden sheet - which makes it a bit harder to bring it back (need VB-code).

I presume you already know how to password-protect a sheet...menu: Tools>Protection>...

Hope this gave you some new ideas
Ola Sandström

Thanks for the info. SO, how does user1 sees the tab ? Invisible??? And how does user2 who needs to view the page can view that?

Thanks

The User will not see that the Worksheet exists - at all.
The Administrator should have a password on his VBAproject (see encl picture) - rightclick on VBAproject.
Then he can toggel the properties.

Hope this helped
Ola Sandström


http://www.ozgrid.com/Excel/hiding-excel-worksheets.htm
Also try search for Hiding Worksheets on Google