Locking Cells or worksheets
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?
|