COMMENT BOX PICTURE

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

Guest

Is there anyway I can have a certain pic in all of my comments, I'm able to
have a pic in my comments but I have to put the pic in each cell
individually, I would like for the pic to be in all of my comment as the back
ground.
 
You could record a macro while doing it once, then turn the macro into a
useful procedure that applies the picture to all comments:

Sub CommentBackgroundPicture()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Fill.UserPicture sPIC_FILENAME
Next
End Sub

- Jon
 
Back
Top