Is there a macro that will display ONLY the comments in the workbook or
worksheet?

Hi Maural,
Yes see
http://www.mvps.org/dmcritchie/excel/ccomment.htm
and also the related area of the same page.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
Is there a macro that will display ONLY the comments in the workbook or
worksheet?

I took a look at all those examples, but what I am looking for is a
macro that will remove the data in a cell and display only the comment
in the same cell

I found this code, which I beleive was writtrn by you, which will
replace the data with the comments and it works. How can I change the
code to make it a toggle?

Hi Maura,
Make the code toggle between what and what.

Not knowing which code you are referring to, I presume that
it replaces the text in the cell with it's own comment, and then
removes the comment. If that is the case, as written, it wouldn't be
reversible. And I can't think of what else you might want to toggle
if that is the macro (which I don't know where you found it).

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
I found this code, which I beleive was writtrn by you, which will
replace the data with the comments and it works. How can I change the
code to make it a toggle?

I have cells with the last name and also have a comment in all of those
cells with the space number for that last name.
I would like a macro with a shortcut key that woild toggle the display
from last name to space number and later back to last name

Assuming that a referenced cell address is what you refer to as a space
number --

Use of a hyperlink would allow you to actually jump to the cell
you want to reference, and you would not even need a comment.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
I have cells with the last name and also have a comment in all of those
cells with the space number for that last name.
I would like a macro with a shortcut key that woild toggle the display
from last name to space number and later back to last name