Unlocked protected hyperlink to defined range not work but others

M

Moily

I’m using Excel 2003 and having some problems with hyperlinking. The
workbook has several sheets and this problem is only happening with the one
sheet – the other sheets work fine for all kinds of hyperlinking. The
problem on the one sheet is this:

When unprotected everything is working normally. When protected (all
relevent cells are unlocked): Hyperlinks to other worksheet work, Hyperlinks
to external website work, Hyperlinks to defined ranges (by name) within same
worksheet DO NOT work. (There are two defined ranges that I defined myself
that I’m linking to within the worksheet)

Can you help?
 

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

Top