Lock Cells with Hyperlink

  • Thread starter Thread starter Storm_21_924
  • Start date Start date
S

Storm_21_924

Hey guys,

This should be pretty simple if possible, but I"m just not able to
figure it out.. I'm 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 can't 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
 
Hey guys,

This should be pretty simple if possible, but I"m just not able to
figure it out.. I'm 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 can't 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
Click to expand...

Anything? Anyone?
Help! :)
 
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
 
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




- Show quoted text -
Click to expand...

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