Forum Discussion
Rui_Dias_Ruca
Jun 26, 2024Copper Contributor
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 fo...
NikolinoDE
Jun 26, 2024Platinum Contributor
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.