ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Modify default size of insert comment (https://www.excelbanter.com/new-users-excel/237319-modify-default-size-insert-comment.html)

Esgrimidor

Modify default size of insert comment
 
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

Bernie Deitrick

Modify default size of insert comment
 
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




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.



Esgrimidor

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

Gord Dibben

Modify default size of insert comment
 
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



Esgrimidor

Quote:

Originally Posted by Gord Dibben (Post 859784)
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.

Esgrimidor

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.


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com