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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
Copy Text into comment box 3
Mixing data from 2 different tables 1
Event Handlers: Getting a handle to the calling object 8
cell comments, hiding columns, "Cannot shift objects off sheet" 1
Need help with Syntax 6
Copying a Picture From Cell Comment 0
Adding formatting rules for Comments in Macro 2

Back
Top