ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Allowing Hyperlink to Work on Protected Worksheet (https://www.excelbanter.com/excel-programming/416726-allowing-hyperlink-work-protected-worksheet.html)

JAD

Allowing Hyperlink to Work on Protected Worksheet
 
I have a hyperlink that I have unlocked. Whenever I protect the worksheet,
the hyperlink looks like it is responding but doesn't take me to the location
desired. Instead I stay in the same location. With protection disabled, it
works as predicted. Any help would be appreciated. Thank You, JAD

Héctor Miguel

Allowing Hyperlink to Work on Protected Worksheet
 
hi, !

I have a hyperlink that I have unlocked. Whenever I protect the worksheet
the hyperlink looks like it is responding but doesn't take me to the location desired.
Instead I stay in the same location. With protection disabled, it works as predicted.
Any help would be appreciated...


i just added an hyperlink (the cell locked and unlocked) to other sheet in same workbook
protected both or either worksheet/s and hyperlink is working just fine -?-

do you have any detail/s not commented in your post ?

regards,
hector.




All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com