Excel - Lock Cells with Hyperlink

Asked By Storm_21_924 on 12-Jan-10 03:06 PM
Hey guys,

This should be pretty simple if possible, but I"m just not able to
figure it out.. I am thinking I just overlooked it.

I have cells with hyperlinks that I want to lock.  If I protect the
sheet and do not allow the cells to be selected, the hyperlink will
not work.  If I protect the sheet and allow the cells to be selected,
it works.  The cells are locked to they cannot be edited.  The problem,
not really a problem, but If I choose to allow select cells when
protected, all the cells on the sheet can be selected, whether locked
or unlocked.

Is there a way I can protect the sheet and still only allow unlocked
cells to be selected without unlocking the cells with hyperlinks?  and
not allowing all of the cells on the sheet to be selected?

Sorry if this was info overload, but trying to explain as best I can.

Thanks!
Shaun




Storm_21_924 replied to Storm_21_924 on 13-Jan-10 10:58 AM
,

Anything?  Anyone?
Help! :)
Gord Dibben replied to Storm_21_924 on 13-Jan-10 12:10 PM
Why does it matter that you can select locked cells?

If they are locked they cannot be altered or edited so no harm done.


Gord Dibben  MS Excel MVP
Storm_21_924 replied to Gord Dibben on 13-Jan-10 01:37 PM
,
lem,
nd

Its more for the appearance... I know that it is functional as is.. I
was trying to clean it up a bit..