I have an alphabetical list of names and i have hyperlink at the top of letters so that when the user click on a letter they are taken to the beginning of the section in the list of names that start with that letter...it worked great until i protected the sheet and now when i click on a link nothing happens...is there a way to use hyperlinks on a protected sheet or are they not meant for that??
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can hyperlinks be used on a protected sheet??
- Thread starter pliant
- Start date
Re: Can hyperlinks be linked to a locked cell??
ok i think it has more to do with the cell that the hyperlink points to is marked as locked which is right since i do not want the user to be able to edit it but now the link will not jump to it...is there anyway to have a hyperlink to a locked cell?
ok i think it has more to do with the cell that the hyperlink points to is marked as locked which is right since i do not want the user to be able to edit it but now the link will not jump to it...is there anyway to have a hyperlink to a locked cell?
Upvote
0
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
What version of Excel are you using?
With 2002, the only way I could replicate your problem after protecting the sheet was if I unchecked the boxes for select unlocked/locked cells.
With 2002, the only way I could replicate your problem after protecting the sheet was if I unchecked the boxes for select unlocked/locked cells.
Upvote
0
i solved the problem...i had set the EnableSelection off all sheets in the workbook to xlUnlocked cells...so it wouldn't allow the link to select a locked cell...i changed it to xlNoRestrictions on the sheet with the hyperlink and it works fine :D
Upvote
0
