#1
|
|||
|
|||
Comments Seem to be Disabled in Some Files
I can insert comments into the worksheets of most of my Excel 2000 files at any time. But some files in which I have already inserted comments, I cannot insert a new comment in any of the file's worksheets. When I select and then right-click on a cell that is formatted as "General" there is no "Insert Comment". And if I select and right-click on a comment there isn't any way to edit it.
I've checked in Tools>Options>View and verified that "Comment indicator only" is enabled. I can't find any other option about Comments in the Excel Help file. I've noticed that "[Group]" appears after the filename in the Title bar (see attachment) in files that have the problem, so that must have something to do with the problem. 1. How do I get rid of the [Group] in the title bar? 2. How can I enable Comments in those files? |
#2
|
|||
|
|||
Fixed!
To remove the "Group" word from the Title bar I first selected all of the worksheets in one of the problem files. Then I right-clicked and lo and behold, "Ungroup" appeared in the menu. I clicked that and then the word "Group" was removed from the filename in the Title bar. I have not the foggiest idea how that word appeared, but I must have done something in the last couple of months to make it appear. Anyhow, the file is now "ungrouped" and I am happy-happy. Last edited by skeezix; 03-10-2022 at 07:44 AM. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error 4605 when looping through files in folder and deleting comments | Peterson | Word VBA | 2 | 04-19-2018 08:45 AM |
Macros are disabled | gstech | Excel Programming | 1 | 12-06-2017 10:28 AM |
Converting 'comments' into text files (2 questions) | Paul Lance | Word | 1 | 04-29-2013 06:00 PM |
comments disappear in docx files | techwriterrc12 | Word | 4 | 03-13-2013 07:05 AM |
Editing disabled | ubns | Word VBA | 0 | 08-30-2012 12:21 AM |