About Us

Don Guillett

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Delta Tango" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Delta Tango" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Delta Tango" <Delta wrote in message
...
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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperlink defult font	[email protected]	Excel Discussion (Misc queries)	1	December 30th 07 11:33 AM
how do I change default settings for Comments (its font, etc.)	bromm	Excel Discussion (Misc queries)	1	April 16th 07 11:01 PM
How can i hide comments given in Excell sheet	Hide comments which are visible	Excel Discussion (Misc queries)	1	March 22nd 07 06:14 AM
Cell Comments randomly move and resize regardless of settings	Andrew	Excel Discussion (Misc queries)	0	August 24th 05 08:49 PM
How to you lockout the comments in Excell from other users?	rescue336	Excel Discussion (Misc queries)	2	May 13th 05 06:01 PM

Menu

About Us