**HYPERLINKS ON PROTECTED SHEET
 

I submitted this a few days ago, but no answers yet. I'm hoping someone can
help.

I have a worksheet that I have protected specific cells from being modified,
although non-protected can be changed. I have also added hyperlinks on the
same worksheet, which allows you to jump to different areas of the worksheet.


Unfortunately, if I protect the sheet, the hyperlinks won't work, even
though they're in un-protected cells.

Is there a way to make the hyperlinks work on the protected sheet?

**HYPERLINKS ON PROTECTED SHEET
 

Hyperlinks to a protected cell on a sheet will work provided that when you
protect the sheet "Allow users to select locked cells" is checked.
Mike

"Todd" wrote:

I submitted this a few days ago, but no answers yet. I'm hoping someone can
help.

I have a worksheet that I have protected specific cells from being modified,
although non-protected can be changed. I have also added hyperlinks on the
same worksheet, which allows you to jump to different areas of the worksheet.


Unfortunately, if I protect the sheet, the hyperlinks won't work, even
though they're in un-protected cells.

Is there a way to make the hyperlinks work on the protected sheet?

**HYPERLINKS ON PROTECTED SHEET
 

I use xl2003 and in my simple test (insert|hyperlinks) with the worksheet
protected, it worked ok.

Todd wrote:

I submitted this a few days ago, but no answers yet. I'm hoping someone can
help.

I have a worksheet that I have protected specific cells from being modified,
although non-protected can be changed. I have also added hyperlinks on the
same worksheet, which allows you to jump to different areas of the worksheet.


Unfortunately, if I protect the sheet, the hyperlinks won't work, even
though they're in un-protected cells.

Is there a way to make the hyperlinks work on the protected sheet?

--

Dave Peterson