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

D

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.
 
D

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
 
D

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?
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top