| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks for posting your workaround.
foxcole wrote: We finally concluded that the protection setting on that sheet was a result of corruption, so copied the content into a new sheet (having to first switch to another sheet to insert a new one--the protection on the corrupt sheet didn't allow us to insert from there) and deleted the original. The new sheet behaves as it should. I wish I'd thought of that sooner. Thanks for taking the time to look at this, though! --Fox "Dave Peterson" wrote: This seems a stretch--but I couldn't get excel to disable that "edit comments" option on the rightclick menu--no matter what I did. Any chance that there's a macro that's stopping you. If you open the workbook with macros disabled, does it work? And I'm confused about the "unprotect sheet" command. If the worksheet is not protected, then you shouldn't see "unprotect sheet". Tools|protection|protect sheet makes more sense to me. Am I looking at the correct menu items (on the rightclick menu and on tools|protection)? foxcole wrote: My coworker is using a spreadsheet with comments, but can't edit the comment box. 'Edit comment' is disabled, as is the 'unprotect sheet' command. The workbook is not protected, and other sheets in the workbook are fine--it's just a problem with this one sheet. We've looked everywhere, but haven't found any settings or options that would affect this. Any ideas? TIA! -- FoxCole "Drawing on my fine command of the English language, I said nothing." Robert Benchley (about his response to someone who said at a dinner party, "Say something funny, Mr. Benchley.") -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comments | Excel Discussion (Misc queries) | |||
| Can Comments be automatically converted to text cell values? | Excel Discussion (Misc queries) | |||
| How to switch to edit the cell | Excel Discussion (Misc queries) | |||
| save comments to a worksheet | Excel Worksheet Functions | |||
| I can't edit excel by right clicking | Excel Worksheet Functions | |||
Threaded Mode
