View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Barb is offline
external usenet poster
 
Posts: 70
Default How to call "Hide Comment" from VBA???

Hi,

I created a comment in a cell with VBA. I don't know why but it
stays open instead to be closed. Can I call the same "Hide comment" that we
see when we right click on that cell?

range("A40").NoteText Text:="bla bla bla"
' to close the comment
range("A40").HideComment ????????