my comments won't change font!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Albert - 30 Sep 2006 17:46 GMT

Hi!
I'm trying to change the font on my comments, but it doesn't work.
I'm doing the following:
1. Right click on cell with comment
2. Modify comment
3. Select whole comment
4. Select different font
and..... nothing happens!
Could you give me a hand?
Thanx in advance,
Albert

Reply to this Message

Gary''s Student - 30 Sep 2006 23:58 GMT

Hi Albert:

There is a tiny trick!

After you have select all the text in the comment (step #3)
Right-click and pick Format comment...
Pick your font from the resulting dialog

Signature

Gary's Student

> Hi!
> I'm trying to change the font on my comments, but it doesn't work.
[quoted text clipped - 7 lines]
> Thanx in advance,
> Albert

Reply to this Message

Albert - 01 Oct 2006 00:13 GMT

Hi Gary's Student:
Thanx for your suggestion.
However, it only seems to work sporadicaly.
For example, it works when I pick the font "Terminal", but it doesn't when I
pick "Courier New" (it shows the default Tahoma).
What to do?
Thanx again,
Albert

Reply to this Message

Dana DeLouis - 20 Nov 2006 18:31 GMT

Here's a macro that changes all the Comments on the sheet.
Adjust as necessary.

Sub Comments_AutoSize()
Dim MyComments As Comment
For Each MyComments In ActiveSheet.Comments
With MyComments.Shape.TextFrame
.Characters.Font.Name = "Courier New"
.Characters.Font.Size = 10
.AutoSize = True
End With
Next
End Sub

Signature

HTH :>)
Dana DeLouis
Windows XP & Office 2003

> Hi Gary's Student:
> Thanx for your suggestion.
[quoted text clipped - 5 lines]
> Thanx again,
> Albert

Reply to this Message