default font(size) in Comments

[Robert]

I would like to change the default font and fontsize used in Comments.
Have found the setting in Windows but cannot find it in Office X (SR 1)
for Mac.

Help is appreciated!!!

Robert

 

[JE McGimpsey]

I would like to change the default font and fontsize used in Comments.
Have found the setting in Windows but cannot find it in Office X (SR 1)
for Mac.

AFAIK, there is no user-accessible setting for default font/fontsize in
any MacXL version (there isn't in WinXL, either, at least in XL02 and
earlier versions - you instead change the default Windows settings)

One workaround would be to put this macro in your Personal Macro
Workbook and use Tools/Customize to attach the macro to the
Insert/Comment command.

Or, you could instead attach it to a new toolbar button or keyboard
shortcut:

Public Sub NewInsertComment()
Dim oComment As Comment
With ActiveCell
Set oComment = .Comment
If oComment Is Nothing Then
.AddComment
With .Comment
With .Shape.TextFrame.Characters.Font
.Name = "Arial"
.Size = "12"
.FontStyle = "Regular"
End With
.Text Text:=Application.UserName & ":" & vbNewLine & ""
.Shape.TextFrame.Characters(1, _
Len(.Text) - 1).Font.Bold = True
.Visible = True
End With
End If
End With
End Sub