View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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?