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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top