comment format

×

מיכ×ל (מיקי) ×בידן

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
 
G

Gord Dibben

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

Top