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

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
<(E-Mail Removed)> 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?

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
> <(E-Mail Removed)> 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?
>
> .
>

Good to hear.

Gord

On Tue, 12 Jan 2010 07:16:03 -0800, Bonita
<(E-Mail Removed)> 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.