Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Changing Default Comment Font

Posted by Randy on February 08, 2002 6:55 PM

How do you change the default font of newly inserted comments?
Mine is currently set for Tahoma at size 8.
I can't find anywhere in the options to change that.

Thanks.

Randy

Re: Changing Default Comment Font

Posted by DMV on February 08, 2002 7:21 PM

Select the range you want to change
Right Click
Select "Format Cells"
Go to the FONT tab
Make your changes

Re: Changing Default Comment Font

Posted by DMV on February 08, 2002 7:42 PM

Re: Changing Default Comment Font

Posted by Ivan F Moala on February 08, 2002 10:58 PM

This is set by the OS. You have to change this
via;
Right click Desktop
Select properties
Select appearance
Select Item > Tooltip

Change font/size and colour here.

HTH

Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.