VBA - Hide and protect different ranges with different passwords

[offset]

Hi all,

I have a protected sheet with different ranges that are hidden.

Is it possible write a code that unprotect only one of the hidden ranges? Then I want different passwords for all the ranges.

For example:

A workbook are sent to two different people with sensitive information.

Two ranges are hidden: Row 5-10 and row 15-20

Person 1 need to be able to unhide row 5-10 with a password, while still not able to unhide row 15-20 as it has another password.

Is that possible?

I know it might be easier to use multiple sheets and hide each sheet with it's own password, but however I would like it to be in the same sheet.

Thanks in advance.

 

[sijpie]

Not using Excel's sheet protection.
What you can do is write your own passwordmanager for this purpose, and then when the one password is entered unprotect the sheet, unprotect the 1st hidden range, then protect the sheet again. And on saving the file do the reverse, so the file can only be saved fully protected. For the other hidden area you do the same linked to the other password.

Sounds easy, but lot of pitfalls. How are you going to store the passwords so they can't be cracked?


So your back-up plan is probably best. If the data is really sensitive, you should send the various people different copies of the workbook, where the information they are not entitled to is removed. Because cracking a workbook is not very difficult.