excel - how to change the format for all comments globally

[diana]

Using Excel 20007

Many comments exist in an excel spreadsheet. A request has been made to change the formatting globally for all comments.
If you like set a "template" for comments.

Ive found code to perform this function and I can do this.

Sub cformat()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.TextFrame.Characters.Font.Size = 10
cmt.Shape.TextFrame.Characters.Font.Name = Arial
Next cmt
End Sub


However, this is for a user, and users wont know how to set and run code.

Is there a way this can be done using excel front end?

many thanks

diana

[HansV]

As far as I know, there is no way to select or format all comments at once in the Excel interface.

You could make the macro available to all users through an Excel add-in (.xlam).

[diana]

thank you Hans

diana