Modify default size of insert comment

I would like to modify in Excel 2002 the standard size of the insert comment window.

how can i do ?




Thankssss

You need to change the Tooltip font for Windows. Right-click your desktop, choose Properties, and
then Appearance, and choose "Advanced" then choose Tooltip under item.

HTH,
Bernie
MS Excel MVP


"Esgrimidor" wrote in message
...

Modify default size of insert comment

I would like to modify in Excel 2002 the standard size of the insert
comment window.

how can i do ?

'[image:
http://img529.imageshack.us/img529/4554/screenshot1247942672.th.jpg]'
(http://img529.imageshack.us/i/screenshot1247942672.jpg/)
'[image:
http://img196.imageshack.us/img196/9301/screenshot1247942659.th.jpg]'
(http://img196.imageshack.us/i/screenshot1247942659.jpg/)

Thankssss




--
Esgrimidor

I don't understand

I put screenshot. May be I can follow you if you indicate the option in your system.

I'm using windows xp pro.

I only wanto to change the size of the insert comment windows inside Excel, not the font in the operating system. I suppose we are talking about the same.

Thankssxxx

You cannot change the default size of the Comment dialog box.

You can change the default Tahoma font size only as Bernie suggests.

You would have to use VBA to re-size existing Comments or to insert a new
comment of a specific size.

See Debra Dalgleish's site for codes.

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

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



Gord Dibben MS Excel MVP


On Mon, 20 Jul 2009 23:11:14 +0100, Esgrimidor
wrote:


I only wanto to change the size of the insert comment windows inside
Excel, not the font in the operating system. I suppose we are talking
about the same.

Thankssxxx

I think that's exactly what i need.

I'll take a look.

I would like a simple code for inserting in the proper place. I'm not a programmer, only a user.

I see enormous possibilities, but I only want enter in excel . Put a comment bigger with right click comment in a cell ........

Change the default size of the comment with code.

I don't see tha possibility in the links.

sorry

I hope your help.