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 ????????

How to call "Hide Comment" from VBA???
 

I turned on the macro recorder (tools=Macro=Record a Macro) and hide
comment using the right click popup menu. this was what was recorded:

ActiveCell.Comment.Visible = False

--
Regards,
Tom Ogilvy


"Barb" wrote:

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 ????????