View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.