Thread: How to alter comments in a locked cell ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default How to alter comments in a locked cell ?
When you protect the worksheet, allow users to edit objects, and you
will be able to edit the comments.

torben wrote:
The problem: The sheet is locked, however one cell has been allowed to be
changed by using password. Having typed the password, you can change the
contens in the cell, but you are not allowed to change a linked comment to
the cell. How can that be changed?

Eny good ideas?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote