• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Password Protect Sheets in a workbook

N

nishant.vig

New Member
Greetings,


I have an Excel workbook that I want to share with about 22 team members. The workbook has as many individual sheets in it. I want to password protect each sheet so that one can not see the sheet of others.


e.g. Sheets are named as A, B, C, D and the access of these sheets is given to 1, 2, 3, 4 respectively. Now if 1 clicks on C he should be asked for a password and also he should not see the content of C till the time he puts in the correct password.


Thanks,

Nishant Vig
 
Nishant

1. Hide all sheets (use Very Hidden)

2. Add a Front Page/Index page which has a list of appropriate sheets

3. Use Buttons to Run macro's which will prompt a Name/Password.

4. Then Macro will unhide appropriate sheets.

5. Macro can Automatically close all sheets on workbook close or user button or user change back to index sheet

6. Password Protect macro sheet so people can't hack


This will be best done in VBA
 
You must log in or register to reply here.
Back
Top