| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I protect data in a cell, but allow comments to be entered.
Hi All,
I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla within them cannot be edited/removed, however, I would like all users to be able to insert comments in these fields. The edit objects selection when protecting the sheet allows for comment entry, but it also allows the user to alter the data in the cell. Any solutions/ advise on this would be greatly appreciated. Many Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protect cells but allow to enter data but not remove once entered | Excel Discussion (Misc queries) | |||
| protect cells only after information is entered | Excel Discussion (Misc queries) | |||
| How do I lock unclock cells to protect the data entered? | Excel Worksheet Functions | |||
| Protect data in cells after entered | Excel Discussion (Misc queries) | |||
| Excel 97 Protect but allow comments | Excel Discussion (Misc queries) | |||
Threaded Mode
