| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to alter comments in a locked cell ?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to alter comments in a locked cell ?
Thanks, but the all users will be able to change all comments and not only
userne with a password to celected cells. It must be posible to gain access to only to selected cells. "Debra Dalgleish" skrev: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alter Text in 900 cell entries | Excel Worksheet Functions | |||
| Locked Cell - can still edit | Excel Worksheet Functions | |||
| edit comments in locked cells | Excel Worksheet Functions | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
| how to alter cell format if cell contains text | Excel Worksheet Functions | |||
Hybrid Mode
