Comments.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DB. - 18 Jul 2006 15:46 GMT

I have two workbooks which have comments on a few of their cells.
As is appropriate, when I point to each of those cells the comments they
contain appear alongside.
But often (not always), after I have saved the workbook then opened it
up again on my return, I find that none of my comments appears when I point
at it.
Comments can be made visible again by selecting any cell containing a
comment, clicking Insert --> Edit Comment, then exiting without changing
anything. All comments on that worksheet are now available to me.
Next time I return to the workbook my comments may be available - or,
equally, they may not.
Can anyone explain to me what is happening here, please?

Signature

DB.

Reply to this Message

SteveW - 18 Jul 2006 16:17 GMT

Nobody at Microsoft can explain comments :)

I have a file with a major use for comments - its a real pain in the neck.
Like you say they jump up all over the place when you go to edit them.
you can't search them (easily)

They could have been a really useful addition but imo they (microsoft)
missed a trick here.

> I have two workbooks which have comments on a few of their cells.
> As is appropriate, when I point to each of those cells the comments
[quoted text clipped - 11 lines]
> equally, they may not.
> Can anyone explain to me what is happening here, please?

Signature

Steve (3)

Reply to this Message

DB. - 18 Jul 2006 16:40 GMT

> I have two workbooks which have comments on a few of their cells.
> As is appropriate, when I point to each of those cells the comments
[quoted text clipped - 8 lines]
> equally, they may not.
> Can anyone explain to me what is happening here, please?

"SteveW" replied:

Nobody at Microsoft can explain comments :)

I have a file with a major use for comments - its a real pain in the neck.
Like you say they jump up all over the place when you go to edit them.
you can't search them (easily)

They could have been a really useful addition but imo they (Microsoft)
missed a trick here.

Thanks, Steve.

I now notice that if I have my worksheet (comments available) open in
one window and open Outlook Express in another, then the comments are no
longer available. But my workbook has two sheets, and if I tab to the other
sheet, then tab back again I get the comments again!
I imagine your "Nobody at Microsoft can explain comments :)" may best
sum it up!

Signature

BW's,
DB.

Reply to this Message

Dave Peterson - 18 Jul 2006 18:35 GMT

Why can't you search them easily?

Edit|find|Options button|Look in Dropdown|Comments

> > I have two workbooks which have comments on a few of their cells.
> > As is appropriate, when I point to each of those cells the comments
[quoted text clipped - 31 lines]
> BW's,
> DB.

Signature

Dave Peterson

Reply to this Message

SteveW - 18 Jul 2006 21:21 GMT

I don't have an Options button :)
But thanks for the reminder.
This does work, but for some reason you can't have Formula and Cells

> Why can't you search them easily?
>
[quoted text clipped - 48 lines]
>> BW's,
>> DB.

Signature

Steve (3)

Reply to this Message

Dave Peterson - 18 Jul 2006 22:43 GMT

What do you mean by Formula and Cells?

If you mean: Formula and Comments?

Then, yep. You have to do it twice.

> I don't have an Options button :)
> But thanks for the reminder.
[quoted text clipped - 55 lines]
> --
> Steve (3)

Signature

Dave Peterson

Reply to this Message

SteveW - 18 Jul 2006 23:17 GMT

typo :)

Back to the OP, I have a set of macros that create a comment, of specific
size, style etc
with initial contents.
These stay happily with the cell whenever I edit them
But if lines of the sheet are hidden before the cell with the comment,
then Comment Edit, brings up the comment *where it would have been if the
lines hadn't been hidden*

Fine if it's one or two, but a hundred or more out is annoying, especially
when the current cell is moved off the screen to show the comment and then
when the comment edit is finished, the screen doesn't move back to where
it was :(

Steve

> What do you mean by Formula and Cells?
>
[quoted text clipped - 67 lines]
>> --
>> Steve (3)

Signature

Steve (3)

Reply to this Message