Excel Work Sheet Comments

[Guest]

Is there a way to change the default setting for comments to a different font
& point size that covers the whole work sheet rather than making changes to
each individule comment?

 

[Max]

Try this (It's a windows setting)

Right-click on any empty space in the desktop > choose Properties

Select Appearance tab > Advanced button
(in Win XP)

In the Advanced Appearance dialog:
Click on "Item" dropdown menu > choose Tooltip
Choose a font type and its size > OK > Apply

 

[Guest]

My friend, your're a MSN Wizard. You just same me an awful lot of work.
Thank you so much.

 

[Gord Dibben]

Max

Don't think you can change the default font from Tahoma.

You can change font size using your method, but the font type change doesn't
affect Excel Comments AFAIK.

To change font type you must run code or edit manually.

Debra D. has code at her site

http://www.contextures.on.ca/xlcomments03.html


Gord

 

[Max]

Thanks for correction, Gord !
Yes, you're right ..

 

[Max]

You're welcome !

But pl see Gord's note on font change