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 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?

--
DB.

Comments.
 

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.



On Tue, 18 Jul 2006 15:46:16 +0100, DB. wrote:

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?




--
Steve (3)

Comments.
 

On Tue, 18 Jul 2006 15:46:16 +0100, DB. wrote:

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!
--
BW's,
DB.

Comments.
 

Why can't you search them easily?

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

"DB." wrote:

On Tue, 18 Jul 2006 15:46:16 +0100, DB. wrote:

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!
--
BW's,
DB.

--

Dave Peterson

Comments.
 

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




On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
wrote:

Why can't you search them easily?

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

"DB." wrote:

On Tue, 18 Jul 2006 15:46:16 +0100, DB.
wrote:

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!
--
BW's,
DB.




--
Steve (3)

Comments.
 

What do you mean by Formula and Cells?

If you mean: Formula and Comments?

Then, yep. You have to do it twice.





SteveW wrote:

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

On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
wrote:

Why can't you search them easily?

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

"DB." wrote:

On Tue, 18 Jul 2006 15:46:16 +0100, DB.
wrote:

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!
--
BW's,
DB.


--
Steve (3)

--

Dave Peterson

Comments.
 

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

On Tue, 18 Jul 2006 22:43:20 +0100, Dave Peterson
wrote:

What do you mean by Formula and Cells?

If you mean: Formula and Comments?

Then, yep. You have to do it twice.





SteveW wrote:

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

On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
wrote:

Why can't you search them easily?

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

"DB." wrote:

On Tue, 18 Jul 2006 15:46:16 +0100, DB.
wrote:

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!
--
BW's,
DB.


--
Steve (3)




--
Steve (3)