| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
turn on insert comments ability in Excel
I have an Excel file with the ability to insert comments turned off. I need
to turn it on. The 'show insert options' button is checked. I still can't insert comments. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn on insert comments ability in Excel
Sounds like the cell you're attempting to add the comment to is locked due to
worksheet protection being turned on. -- Kevin Backmann "dave parta" wrote: I have an Excel file with the ability to insert comments turned off. I need to turn it on. The 'show insert options' button is checked. I still can't insert comments. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn on insert comments ability in Excel
Unprotect the sheet or if you need it protected, check the "Edit Objects" option
when protecting the sheet. Note: "show insert options" has nothing to do with inserting Comments. That just pops up a dialog of choices when you insert a row or cell. Gord Dibben MS Excel MVP On Fri, 11 Apr 2008 07:10:06 -0700, dave parta wrote: I have an Excel file with the ability to insert comments turned off. I need to turn it on. The 'show insert options' button is checked. I still can't insert comments. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I turn off the insert function dialog box in excel formulas | Excel Worksheet Functions | |||
| How Do I turn off indicators and comments? | Excel Discussion (Misc queries) | |||
| Why can't I insert comments on my spreadsheet? | Excel Discussion (Misc queries) | |||
| Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
| Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
Hybrid Mode
