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?

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Evans-DC" wrote in message
...
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?

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

"Max" wrote:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Evans-DC" wrote in message
...
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

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

On Wed, 9 Feb 2005 22:44:33 +0800, "Max" wrote:

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

Thanks for correction, Gord !
Yes, you're right ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

You're welcome !

But pl see Gord's note on font change

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Evans-DC" wrote in message
...
My friend, your're a MSN Wizard. You just same me an awful lot of work.
Thank you so much.