Comment Formatting

  • Thread starter Thread starter W. Michael Duewel
  • Start date Start date
W

W. Michael Duewel

I would like the default for my comments to be 8pt Ariel
regular face and for the comment box to open without my
name.

How can I set the default for comments or where can I
find information on setting the default for comments.

I appreciate your help.


WMD in Houston
 
Hi WMD!

To change default font size in comments:

Start > Control Panel > Display > Appearance
In Windows XP you need to click Advanced
From the Dropdown select ToolTip and change font and size

But be aware that this affects ToolTips generally and not just
comments.

Without VBA you can change the name using:

Tools > Options > General
Change the User name to something like Note

With VBA:

From: Debra Dalgleish
http://www.contextures.com/xlcomments03.html#Plain

Sub CommentAddOrEdit()
'adds new plain text comment or positions
'cursor at end of existing comment text
Dim cmt As Comment
Set cmt = ActiveCell.Comment
If cmt Is Nothing Then
ActiveCell.AddComment text:=""
End If
SendKeys "%ie~"
End Sub

You'll also find on that web site code for inserting standard
formatted comments with no user name.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
You can change the font size of new comments by changing the settings in
your Control Panel. (Instructions for Windows XP)

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

Or, use code to insert a comment in the font and size that you prefer.
There are instructions here:

http://www.contextures.com/xlcomments03.html
 
Back
Top