I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size.

You can change the default font size only........

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK

To change font type you need VBA code

http://www.contextures.on.ca/xlcomme...html#Formatted


Gord Dibben MS Excel MVP


On Tue, 8 Jul 2008 10:43:00 -0700,
wrote:

I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size.

Thanks much. A fairly obscure location for the change! I'm glad you knew
where it was.

"Gord Dibben" wrote:

You can change the default font size only........

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK

To change font type you need VBA code

http://www.contextures.on.ca/xlcomme...html#Formatted


Gord Dibben MS Excel MVP


On Tue, 8 Jul 2008 10:43:00 -0700,
wrote:

I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size.