Comments.

[DB.]

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?

 

[SteveW]

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.

 

[DB.]

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?

"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!

 

[Dave Peterson]

Why can't you search them easily?

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

 

[SteveW]

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?

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

 

[Dave Peterson]

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.
This does work, but for some reason you can't have Formula and Cells

 

[SteveW]

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