Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can't edit comments
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.") |
#2
|
|||
|
|||
Woops--meant to mention that we use Office 2000.
"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.") |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#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 |
#6
|
|||
|
|||
We accidentally discovered something, just now. In a workbook with many
worksheets, protecting one worksheet appears to randomly apply protection to some of the other sheets as well. On some of them, the 'unprotect sheet' command is available, but others exhibit the behavior mentioned in the original post. I don't see a pattern to it. Ever heard of this before? "Dave Peterson" wrote: 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 |
#7
|
|||
|
|||
No. I've never heard of anything like that.
But there are tons of questions asking how to protect multiple sheets at one time. A macro solution is often given. Any chance you have a "helpful" macro sticking its head in where it doesn't belong. If you open excel in safe mode, you can disable all macros. And do a little testing. Close excel windows start button|run excel /safe foxcole wrote: We accidentally discovered something, just now. In a workbook with many worksheets, protecting one worksheet appears to randomly apply protection to some of the other sheets as well. On some of them, the 'unprotect sheet' command is available, but others exhibit the behavior mentioned in the original post. I don't see a pattern to it. Ever heard of this before? "Dave Peterson" wrote: 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 -- Dave Peterson |
Reply |
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 |