Hyperlinks not working after sheet is protected....




There seems to be a problem with hyperlinks not working when i protect the
sheet so no user can change data (even the hyperlink). I am not using any VBA
or macros at all. I want to use a hyperlink to access a spreadsheet on the
same workbook, but as mentioned before i need to protect the sheet in order
to keep the users from chaning data or making mistakes etc.. but once this is
done all the hyper links stop working.

Any suggestion on how to fix this problem?

Thanks in advance.



Gary''s Student

Be sure you allow users to select locked or protected cells when you protect
the worksheet. Otherwise the hyperlinks won't work.

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