Thread: Comments Only
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Comments Only

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?