| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Allow comments to be added to protected worksheet? - Excel 2007
I have created a worsksheet with selected areas locked and then protected it.
My users want to be able to add comments where necessary but are not able to. I cant seem to find anything in the help menu - any ideas? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Allow comments to be added to protected worksheet? - Excel 2007
When protecting the sheet "allow users to:"
Select unlocked cells and Edit Objects. Note: with edit objects checked, users can insert comments in locked cells if they are allowed to select those. Gord Dibben MS Excel MVP On Wed, 4 Nov 2009 15:00:02 -0800, sue@solotel wrote: I have created a worsksheet with selected areas locked and then protected it. My users want to be able to add comments where necessary but are not able to. I cant seem to find anything in the help menu - any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Comments into Cells of Protected Worksheet | Excel Worksheet Functions | |||
| Adding comments into a protected worksheet | Excel Discussion (Misc queries) | |||
| adding comments to unprotected cell/range in protected worksheet | Excel Worksheet Functions | |||
| Protected worksheet and comments | Excel Discussion (Misc queries) | |||
| Enter comments in a protected Excel worksheet | Excel Worksheet Functions | |||
Linear Mode
