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

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