| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I insert a comment in a protected worksheet ?
I have a worksheet that I protected so that no other users could mess up my
formulas. I only protected those cells with formulas but I want all users to be able to insert and edit comments within the worksheet. Is this possible? |
|
#2
|
|||
|
|||
|
Hi Aylan
If you have 2002 or 2003 you can check "Edit objects" when you protect your sheet ToolsProtection..Protect sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Aylan" wrote in message ... I have a worksheet that I protected so that no other users could mess up my formulas. I only protected those cells with formulas but I want all users to be able to insert and edit comments within the worksheet. Is this possible? |
|
#3
|
|||
|
|||
|
Thank you so much Ron! That was exactly the answer that I needed. It is good
to know that this is so easy and fast. Aylan "Ron de Bruin" wrote: Hi Aylan If you have 2002 or 2003 you can check "Edit objects" when you protect your sheet ToolsProtection..Protect sheet -- Regards Ron de Bruin http://www.rondebruin.nl "Aylan" wrote in message ... I have a worksheet that I protected so that no other users could mess up my formulas. I only protected those cells with formulas but I want all users to be able to insert and edit comments within the worksheet. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you shade in an unlocked cell on a protected worksheet? | Excel Discussion (Misc queries) | |||
| Sorting on a protected worksheet | Excel Discussion (Misc queries) | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
| How do I show protected cells in an EXCEL worksheet | Excel Discussion (Misc queries) | |||
| Insert worksheet | Excel Worksheet Functions | |||
Hybrid Mode
