ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password Protect Worksheet Viewing (https://www.excelbanter.com/excel-programming/304737-password-protect-worksheet-viewing.html)

ByTheLake

Password Protect Worksheet Viewing
 
I have an excel worksheet that has about 8 tabs/worksheets. Eac
worksheet has cell protection to only allow writing to approved cells
Outside of that, I want to password protect each worksheet so that eac
sheet cannot be viewed without a password. Each worksheet represents
different person and I want the ability to 'hide' the informatio
contained in the other worksheets, and only grant access to tha
specific worksheet. I need a solution that will work from multiple PC
and in either 97 or 2000. Any help would be appreciated

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Password Protect Worksheet Viewing
 
Passwords associated with worksheets do not affect the ability of the user
to see the worksheet. The viewing of the worksheet is protected at workbook
level and there is only one password for that.

If you can't separate your sheets into workbooks, you would have to concoct
code the hides and unhides the sheets and administers a password system.
Thus you would not give out the single password for protecting the structure
of the workbook.

Any such system is of minimal security at best as code to break workbook and
sheet level passwords is posted at least weekly on this forum.

--
Regards,
Tom Ogilvy

"ByTheLake " wrote in message
...
I have an excel worksheet that has about 8 tabs/worksheets. Each
worksheet has cell protection to only allow writing to approved cells.
Outside of that, I want to password protect each worksheet so that each
sheet cannot be viewed without a password. Each worksheet represents a
different person and I want the ability to 'hide' the information
contained in the other worksheets, and only grant access to that
specific worksheet. I need a solution that will work from multiple PCs
and in either 97 or 2000. Any help would be appreciated.


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 10:53 PM.

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