Excel protect ranges
Hello all,
I have one Excel file with several work sheets, in the first one I have several hyperlinks for each of the page, with different names, so hyperlink to John will directly open worksheet for John.
I need to send to all team and each of them must have the access only to his own hyperlink / page, not the other, so question:
It’s possible to block parts of the first worksheet with different passwords, meaning I’ll create a password for each user, then when they press the hyperlink with his name, the Excel will ask for the password and allow only that specific cellule / hyperlink.
I tried with “Allow Edit Ranges” but is not working.
Can some of you help me, please?
thank you
Hello all,I have one Excel file with several work sheets, in the first one I have several hyperlinks for each of the page, with different names, so hyperlink to John will directly open worksheet for John.I need to send to all team and each of them must have the access only to his own hyperlink / page, not the other, so question:It’s possible to block parts of the first worksheet with different passwords, meaning I’ll create a password for each user, then when they press the hyperlink with his name, the Excel will ask for the password and allow only that specific cellule / hyperlink.I tried with “Allow Edit Ranges” but is not working.Can some of you help me, please? thank you Read More