ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing Comment box shape by default (https://www.excelbanter.com/excel-discussion-misc-queries/95439-changing-comment-box-shape-default.html)

Samad

Changing Comment box shape by default
 
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.

Jim Rech

Changing Comment box shape by default
 
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.

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



Samad

Changing Comment box shape by default
 
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

"Jim Rech" wrote:

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.

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





All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com