Lock tabs within workbook with Passwords

[lisab0712]

Hi I need to lock individual tabs within a workbook so they can't be viewed without entering a password. I have been told this is done by a macro but i can't find instructions on how to do this.

Any help would be appreciated.

 

[Anfinsen]

Hi I need to lock individual tabs within a workbook so they can't be viewed without entering a password. I have been told this is done by a macro but i can't find instructions on how to do this.

Any help would be appreciated.

To completely lock a sheet for viewing, follow these steps:

1. Right-click the sheet you want to protect (here, Sheet1), and click Hide.

1. Now, protect the workbook. In the Ribbon, go to Review > Protect Workbook.

1. Enter a password, and press OK.

1. Reenter the password to confirm and click OK.

Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. This means you have completely protected your worksheet from viewing.

 

[lisab0712]

To completely lock a sheet for viewing, follow these steps:

1. Right-click the sheet you want to protect (here, Sheet1), and click Hide.

1. Now, protect the workbook. In the Ribbon, go to Review > Protect Workbook.

1. Enter a password, and press OK.

1. Reenter the password to confirm and click OK.

Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. This means you have completely protected your worksheet from viewing.

Thank you for your reply but this isn't what I need. I need multiple people to be able to see the tabs but no access them all only the ones they have passwords for. Any idea how to do this?

 

[Anfinsen]

Thank you for your reply but this isn't what I need. I need multiple people to be able to see the tabs but no access them all only the ones they have passwords for. Any idea how to do this?

You could give the people that need to see them, the password?
The only other option I can think of, is not actually using passwords, but have VBA prompt the user to enter a "password", when opening the workbook, and conditionally hide and lock based on the "password" you define for each user. However, anyone of the users can go into the VBA editor and pause the code and "unlock" all sheets.
This is an interesting problem, if I come across any other ideas, I will let you know.

 

[lisab0712]

You could give the people that need to see them, the password?
The only other option I can think of, is not actually using passwords, but have VBA prompt the user to enter a "password", when opening the workbook, and conditionally hide and lock based on the "password" you define for each user. However, anyone of the users can go into the VBA editor and pause the code and "unlock" all sheets.
This is an interesting problem, if I come across any other ideas, I will let you know.

I believe this is what I need but a different password for each tab so they cant access other people's information. Do you have any instructions on how to do this?

 

[Skyybot]

Select all cells in a sheet and then Protect Sheet. Everybody can see, but only people with password can edit.