COMMENT BOX PICTURE
 

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.

COMMENT BOX PICTURE
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"tankerman" wrote in message
...
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.