ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Hyperlink inactive if sheet protected (https://www.excelbanter.com/links-linking-excel/232503-hyperlink-inactive-if-sheet-protected.html)

Tome de Souza

Hyperlink inactive if sheet protected
 

can anyone guide me?
I have a worksheet with hyperlinks but when I protect the worksheet i
am unable to use the hyperlink even though I have unprotected the range
where the hyperlink is noted




--
Tome de Souza

Ralphael1

Hyperlink inactive if sheet protected
 
On Jun 1, 4:17*am, Tome de Souza <Tome.de.Souza.
wrote:
can anyone guide me?
I have a worksheet with hyperlinks but when I protect the worksheet i
am unable to use the hyperlink even though I have unprotected the range
where the hyperlink is noted

--
Tome de Souza


Greetings, I ran into a similar situation where the hyperlinks were
inactive.
I found that if I manually rentered the hyperlink it worked fine.
Another thing I found was that if the inactive link was in the address
bar I could backspace over the h in http and reenter the h it would
activate the link.
Both methods requires each link to be reworked.

Ralphael, the OLD one


All times are GMT +1. The time now is 09:53 AM.

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