change default comment format

[trout31]

The font that defaults for cell comments is set way too small to read. I wind up changing it everytime. How can I change the default??

 

[mapakunk]

Start, Settings, Control Panel
Double Click Display
Appearance
From the Item drop down menu select Tool Tip
Change the font there

Quite the rig a mo rll huh

 

[trout31]

Thank you for the responce, however I am pretty sure your idea is not my answer. The font that I am having trouble with is not my normal screen display. It is only the default font in the Excel cell comment box. (ie the insert comment function). In fact there is also a defaulted comment that is there initially. It is my computer's name followed by a colon. Of course in tiny little letters that cannot be read. Sorry, this is hard to explain clearly. It seems however that buried somewhere in Excels configuration is the default format for cell comments. I have already verified that the format does not match that of the cell. I have Excel installed on other computers that do not have this same defaulted comment format. Where O Where does it come from?

 

[trout31]

Dear Mapakunk. I owe a thousand apologies. I have verified that your advice was in fact correct. The tooltip font indeed follows through to the Excel comment font. Your are clearly a wise advisor. Thankyou.
trout31

 

[Notewurthy]

mapakunk,

I also had been looking for this solution and am thrilled to have stumbled onto your posting. The only problem I still have is that the font does not transfer to excel. The size, color, and italics transfers but the actual font remains Tahoma. The font does change for the other window tool tips. Any ideas how I can change the font default for comments? Also it would be nice if I could set the default for auto-size as well.

Thanks,
Notewurthy

 

[Yogi Anand]

you may also want to refer to the following thread where a similar issue was discussed

http://www.mrexcel.com/board/viewtopic.php?topic=5244&forum=2&start=0

Regards!

Yogi

 

[Notewurthy]

Thanks Yogi,

I had already been to that thread but my goal is a little different. I want to change the default font so that all future comment boxes start with the new font.

Regards,

Notewurthy