Is it possible to attach a password to a hyperlink?
Is it possible to attach a password to a hyperlink?
Not directly.
You would have to set the cell "locked" property to "on" and apply sheet protection.
If you want a specific passwords for x-number of hyperlinks, then VBA is required.
How would I go about getting the proper VBA code to set a password for a number of hyperlinks? I have no background in this area...
I think the correct approach might be (in basic terms):
1. Protect the worksheet(s) when opening the workbook
2. Prompt for a password when the sheet is activated and then unlock hyperlinked cells associated with the password.
Another possible option in conjunction with the above:
Hide rows or columns which you don't want users to have access to.
Keep in mind that, by design, Excel gives users the privilege of choosing whether or not to enable macros. If a user choose not to enable macros then the VBA code will not run. Point being: Excel is not a secure application by any means and an ambitious, average user could defeat protection.
The place to start is to search the forum (programming section) on the topic of protecting worksheets. Depending on your needs this could become complex and involve the use of Userforms
Here's a start, but it is not specific to hyperlinks, just the idea of protecting the sheet and is something to build on: Password Protect Worksheet From Viewing
Usernames, passwords & privileges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks