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.
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.