I've just tried that but got the message, "Run-time error '438'. Object
doesn't support this property or method.

"Debra Dalgleish" wrote:

Or you could record a macro while you add the comment with a picture,
and run that when you need it. Put the code in a workbook that's always
open, and add a button to one of your toolbars, to run the macro.

Then, select a cell and click the button.

pjk@boro wrote:
I tried that a while ago & it didn't work. I can't remember what the problem
was, now. I'll give it another go.
thanks very much anyway.

"Dave Peterson" wrote:


You could always put a comment in your personal.xls (sheet1?), then use a macro
to copy|paste that comment.

pjk@boro wrote:

Thanks for the suggestion Dave, that's what I currently do. I suppose I'm
just being lazy wanting the system to do it for me.
"Dave Peterson" wrote:


Maybe you could just create your default comment once, then
edit|copy
edit|paste special|Comments
whenever you need that special comment.

pjk@boro wrote:

I've tried right-clicking on the comment & selecting "set auto shape
defaults, to no avail. Is it possible to set up a default comment, containing
a picture, to save having to edit every comment?

--

Dave Peterson


--

Dave Peterson




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html