M
MauraLae
Is there a macro that will display ONLY the comments in the workbook or
worksheet?
worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David McRitchie
Hi Maural,
Yes see
http://www.mvps.org/dmcritchie/excel/ccomment.htm
and also the related area of the same page.
--
Yes see
http://www.mvps.org/dmcritchie/excel/ccomment.htm
and also the related area of the same page.
--
M
MauraLae
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
macro that will remove the data in a cell and display only the comment
in the same cell
M
MauraLae
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?
replace the data with the comments and it works. How can I change the
code to make it a toggle?
M
MauraLae
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
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
D
David McRitchie
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
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