I have a worksheet that people can input data. I have other worksheets that
use this information to summarize the data. I do not want the summarized
worksheets & data to be edited or formulas to be edited. However, I have a
list of hyperlinks in the summarized worksheet that will not work when I
protect the worksheet. Is there a way for the hyperlinks to work?

as long as you allow users to select locked cells when you protect then
hyperlinks will work on a protected sheet.

"Steve" wrote:

I have a worksheet that people can input data. I have other worksheets that
use this information to summarize the data. I do not want the summarized
worksheets & data to be edited or formulas to be edited. However, I have a
list of hyperlinks in the summarized worksheet that will not work when I
protect the worksheet. Is there a way for the hyperlinks to work?

Thanks, Mike. That helps for the most part. However, when I hold down the
cursor, the cell becomes active whereby I can change/delete the hyperlink.
Anyway to eliminate this?

"Mike" wrote:

as long as you allow users to select locked cells when you protect then
hyperlinks will work on a protected sheet.

"Steve" wrote:

I have a worksheet that people can input data. I have other worksheets that
use this information to summarize the data. I do not want the summarized
worksheets & data to be edited or formulas to be edited. However, I have a
list of hyperlinks in the summarized worksheet that will not work when I
protect the worksheet. Is there a way for the hyperlinks to work?

Holding down the mouse button does select the cell but if it protected it
can't be changed only followed.

"Steve" wrote:

Thanks, Mike. That helps for the most part. However, when I hold down the
cursor, the cell becomes active whereby I can change/delete the hyperlink.
Anyway to eliminate this?

"Mike" wrote:

as long as you allow users to select locked cells when you protect then
hyperlinks will work on a protected sheet.

"Steve" wrote:

I have a worksheet that people can input data. I have other worksheets that
use this information to summarize the data. I do not want the summarized
worksheets & data to be edited or formulas to be edited. However, I have a
list of hyperlinks in the summarized worksheet that will not work when I
protect the worksheet. Is there a way for the hyperlinks to work?

Mike,

That was great! I realized that I had the settings wrong in the password
protection screen. Thanks a bunch!

"Mike" wrote:

Holding down the mouse button does select the cell but if it protected it
can't be changed only followed.

"Steve" wrote:

Thanks, Mike. That helps for the most part. However, when I hold down the
cursor, the cell becomes active whereby I can change/delete the hyperlink.
Anyway to eliminate this?

"Mike" wrote:

as long as you allow users to select locked cells when you protect then
hyperlinks will work on a protected sheet.

"Steve" wrote:

I have a worksheet that people can input data. I have other worksheets that
use this information to summarize the data. I do not want the summarized
worksheets & data to be edited or formulas to be edited. However, I have a
list of hyperlinks in the summarized worksheet that will not work when I
protect the worksheet. Is there a way for the hyperlinks to work?