Protection - Hyperlinks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Another question:-

I have used the protection function on a worksheet that contains hyperlinks.

How do I still make these hyperlinks active / useable when the protection is
on?

Cheers
Matthew Balch
 
You need to make sure the cells containing the hyperlink are not locked.
Format>Cells>Protection>uncheck "Locked".

NickHK
 
Thanks

I had done this dut didn't work. Just redid it and now working. Must have
selected the wrong cells to unlock.

*Doh*
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sheet event wait for another event? 6
Open specific hyperlink (accept) automatically in email with outlook 0
code for Allow Insert Hyperlink 2
Securing coded hyperlinks 1
Allowing Hyperlink to Work on Protected Worksheet 1
Finding name of shape that was last clicked - Application.Caller 5
Locked Cells and Hyperlinks 1
Copy hyperlinks 6

Back
Top