change default comment format

trout31 · May 9th, 2002, 08:26 AM

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 · May 9th, 2002, 08:35 AM

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 r

ll huh

trout31 · May 9th, 2002, 06:08 PM

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 · May 9th, 2002, 06:13 PM

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 · Aug 2nd, 2002, 06:00 PM

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 · Aug 2nd, 2002, 08:39 PM

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

http://www.mrexcel.com/board/viewtop...orum=2&start=0

Regards!

Yogi

Notewurthy · Aug 5th, 2002, 02:23 PM

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

May 9th, 2002, 08:35 AM	#2
mapakunk New Member Join Date: May 2002 Posts: 40	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:26 AM	#1
trout31 New Member Join Date: May 2002 Posts: 3	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??

May 9th, 2002, 06:08 PM	#3
trout31 New Member Join Date: May 2002 Posts: 3	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?

May 9th, 2002, 06:13 PM	#4
trout31 New Member Join Date: May 2002 Posts: 3	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

Aug 2nd, 2002, 06:00 PM	#5
Notewurthy New Member Join Date: Aug 2002 Posts: 2	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

Aug 2nd, 2002, 08:39 PM	#6
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	you may also want to refer to the following thread where a similar issue was discussed http://www.mrexcel.com/board/viewtop...orum=2&start=0 Regards! Yogi

Aug 5th, 2002, 02:23 PM	#7
Notewurthy New Member Join Date: Aug 2002 Posts: 2	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