Changing Comment font size?

  • Thread starter Thread starter barch78
  • Start date Start date
B

barch78

Is there a way to change the default font size for the comment box t
something larger than 8? These old eyes having trouble reading th
comments, especially if the sheet is shown on the screen at less tha
100% size. It is time consuming to have to individually change th
comment size one comment at a time
 
Ok, I figured it out and the answer is in the Display Properties unde
Tool Tips.
Two more questions.
1. Where do I revise the Comment setting so the first line of th
comment is not my name.
2. When I set the comment box size, close the document and return t
it a few days later, the box size has changed so that I can't read th
entire comment. How can I fix the box size
 
barch

1. Delete the username in Tools>Options>General

OR run this macro to insert a comment with no name.

Sub PlainComment()
Selection.AddComment text:=""
Selection.Font.FontStyle = "Regular"
Selection.Comment.Visible = False ''True
End Sub

2. Run this macro on selected comments to Auto-size them.

Public Sub Comment_Size()
Dim cmt As Comment
Dim cmts As Comments
Set cmts = ActiveSheet.Comments
For Each cmt In cmts
cmt.Shape.TextFrame.AutoSize = True
Next
End Sub

Gord Dibben Excel MVP
 
.. 1. Where do I revise the Comment setting so the first line of the
comment is not my name.
Click to expand...

Try this:

Click Tools > Options > General tab

In the User name box:
Delete what's inside the box
Enter a space (with the spacebar)

Click OK
 
Back
Top