software

Is there a macro that will display ONLY the comments in the workbook or
worksheet?Hi Maural,
Yes see
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

gt; wrote in message oups.com...
gt; Is there a macro that will display ONLY the comments in the workbook or
gt; worksheet?
gt;
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 cellI 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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

gt; wrote in message oups.com...
gt; I found this code, which I beleive was writtrn by you, which will
gt; replace the data with the comments and it works. How can I change the
gt; code to make it a toggle?
gt;
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 nameAssuming 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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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