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?