Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Comment Function
I have rec'd a spreadsheet containing comments in several cells.
Problem-- Select cell to edit comment. Right mouse click to edit comment. The edit comment selection is not grayed out. Select edit comment and nothing happens. The dialog box goes away. The comment can be viewed by moving the pointer over the cell. Some cells with comments do work properly with edit comment. Any suggestions on how to correct the problem? -- Bonita |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Comment Function
I see this is your second posting and apparently have not received any
replies. Some Comments being editable and others not is a mystery. If you go to View and select Comments do all the Comments show on the sheet? Can you edit now? If the sheet was protected without "edit objects" allowed you would not be able to "edit Comment" any Comment so I don't think that is it. I would like to take a look at your workbook if you cared to send it to me by email. gorddibbATshawDOTca change the obvious. Gord Dibben MS Excel MVP On Mon, 11 Jan 2010 13:58:01 -0800, Bonita wrote: I have rec'd a spreadsheet containing comments in several cells. Problem-- Select cell to edit comment. Right mouse click to edit comment. The edit comment selection is not grayed out. Select edit comment and nothing happens. The dialog box goes away. The comment can be viewed by moving the pointer over the cell. Some cells with comments do work properly with edit comment. Any suggestions on how to correct the problem? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Comment Function
I was able to edit text in the "stubborn" comments. They did not appear
until I moved the pointer over the cells. All others appeared. Thanks for your help. Sorry about the 2 postings. I never saw the first one appear in the listing. -- Bonita "Gord Dibben" wrote: I see this is your second posting and apparently have not received any replies. Some Comments being editable and others not is a mystery. If you go to View and select Comments do all the Comments show on the sheet? Can you edit now? If the sheet was protected without "edit objects" allowed you would not be able to "edit Comment" any Comment so I don't think that is it. I would like to take a look at your workbook if you cared to send it to me by email. gorddibbATshawDOTca change the obvious. Gord Dibben MS Excel MVP On Mon, 11 Jan 2010 13:58:01 -0800, Bonita wrote: I have rec'd a spreadsheet containing comments in several cells. Problem-- Select cell to edit comment. Right mouse click to edit comment. The edit comment selection is not grayed out. Select edit comment and nothing happens. The dialog box goes away. The comment can be viewed by moving the pointer over the cell. Some cells with comments do work properly with edit comment. Any suggestions on how to correct the problem? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Comment Function
Good to hear.
Gord On Tue, 12 Jan 2010 07:16:03 -0800, Bonita wrote: I was able to edit text in the "stubborn" comments. They did not appear until I moved the pointer over the cells. All others appeared. Thanks for your help. Sorry about the 2 postings. I never saw the first one appear in the listing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to edit comment | Excel Discussion (Misc queries) | |||
Edit Comment problem | Excel Discussion (Misc queries) | |||
VBA to edit a comment | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
cannot edit comment | Excel Discussion (Misc queries) |