ExcelBanter - comment format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - comment format (https://www.excelbanter.com/excel-discussion-misc-queries/256697-comment-format.html)

How does one set the default comment format (font, etc)?

I hope I will succeed in translation - as my OS UI is in Hebrew.
* Right click on an empty place in your DeskTop 'Properties...'
* Click the View [or is it display] Tab 'Advanced'
* Open the "Item" Combo-box and scroll down and click the "Tool Description'
choose the font SIZE OK OK.
*** I don't think that changing the font type and/or color will affect the
Comments in Excel.
*** Pay attention that this procedure will change all
*** There is no problem to write a short Macro that will format all the
comments in the active Workbook.
Micky

"whiskeyromeo" wrote:

How does one set the default comment format (font, etc)?

The only attribute you can change is the font size.

Micky has pointed you to Windows Display Properties

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 Comments by programming see Debra Dalgleish's site.

http://www.contextures.on.ca/xlcomments03.html

Gord Dibben MS Excel MVP

On Thu, 18 Feb 2010 09:32:02 -0800, whiskeyromeo
wrote:

How does one set the default comment format (font, etc)?