Comments Only

[[email protected]]

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

[David McRitchie]

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

<[email protected]> wrote in message news:[email protected]...
> Is there a macro that will display ONLY the comments in the workbook or
> worksheet?
>

[[email protected]]

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

[[email protected]]

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?

[David McRitchie]

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

<[email protected]> wrote in message news:[email protected]...
> 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?
>

[[email protected]]

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