| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a comment on an unlocked cell in a protected sheet
Am not able to create a comment on an unlocked cell in a protected sheet.
Creating comments is not one of the features I can enable when protecting the sheet. Please advise if you've faced/solved this problem before. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a comment on an unlocked cell in a protected sheet
Unprotect your worksheet
tools|protection|protect sheet You'll see an object to allow the user to edit Objects (phrasing/location changes with versions of excel). Make sure you allow this. and continue with the protection. Remember that when you allow comments, you're also allowing the users to change other objects, too--shapes/buttons/pictures.... LObeidat wrote: Am not able to create a comment on an unlocked cell in a protected sheet. Creating comments is not one of the features I can enable when protecting the sheet. Please advise if you've faced/solved this problem before. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding comments to unprotected cell in a protected sheet | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Spell Check an Unlocked Cell in a Protected Spreadsheet | Excel Worksheet Functions | |||
| How do you shade in an unlocked cell on a protected worksheet? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
