Forum Discussion
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
2 Replies
- Thanks, yap, I'll ask to update different files and then trough power query I'll compile it, thank you once again
Unfortunately, Excel does not natively support password protection of certain hyperlinks or cells in the way you describe. However, you can achieve similar functionality using VBA (Visual Basic for Applications) to create a more controlled environment. But here too there are limitations or impracticality, such as if the file has to be available in OneDrive, Sharepoint, via Teams, etc.
Hope this will help you.
