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