Lock Cells with Hyperlink

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
 
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

Anything? Anyone?
Help! :)
 
G

Gord Dibben

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
 
S

Storm_21_924

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 -

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

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