Changing Comment box shape by default

S

Samad

I want to change comment box shape (using drawing tool auto shape) by
default. Presently it has to change every time when I insert comment but I
want to fix it permenantly. Is it possible in excel 2003? need help.
 
J

Jim Rech

Your only recourse is to create the comment with a macro that does all the
formatting your want. I'd start by recording a macro as you modify a
comment manually.
 
S

Samad

Yes Jim

Nice Idea, and macro can be activate on button click at toolbar.
I would appreciate if any guru give anyother idea than macro or vb code.

Thanks Jim

Regards
 
Top