How do I change the defult settings for my comments in Excell?

[Delta Tango]

This is a shared worksheet and comment font is extreamly small and when ever
we create a new comment or enter new information into an exsisting comment
the font defults to the tiny font. I need to know how to change the defult
setting for the comments on both Excell 2003 and Excell 2007.

 

[Don Guillett]

You can't do that in Excel. You need to change in windows and you really
don't want to do that cuz it probably changes more than you want throughout
your computer. So, use some kind of macro like

for each c in activesheet.comments
c.shape.textframe.characters.font.size=14
next c

 

[Delta Tango]

Thanks for the macro. It corected all of my existing comments. Although when
I create a new comment that font remains small. is there a way that I can get
the macro to run automaticly when ever a comment is created?

 

[Don Guillett]

How about a macro that creates the comment and changes the font?

 

[Delta Tango]

Hi Don,

I had a friend tell that I should loot at my Zoom seting in the work book.
My zoom was set to 70% when I changed it back to 100% the font was back to
normal size. I think this might be the same issue that other people are
having with there workbooks. Thanks for the Macro though.

Delta Tango

 

[Don Guillett]

http://j-walk.com/ss/excel/usertips/tip075.htm