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?



Gord Dibben

I see this is your second posting and apparently have not received any

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


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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question