comment format

  • Thread starter Thread starter whiskeyromeo
  • Start date Start date
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
 
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
 
Back
Top