formatting of comments
 

Is it possible to format the font of the comments in various cells in a
particular sheet at once.Isit possible to change the taqhoma font to verdana
in the comment boxes all at once

You can do this with formatting. For example, the following code will
change all comments to Verdana, font size 12:

'======================
Sub FormatAllComments()
Dim ws As Worksheet
Dim cmt As Comment
For Each ws In ActiveWorkbook.Worksheets
For Each cmt In ws.Comments
With cmt.Shape.TextFrame.Characters.Font
.Name = "Verdana"
.Size = 12
End With
Next cmt
Next ws
End Sub
'========================


steve wrote:
Is it possible to format the font of the comments in various cells in a
particular sheet at once.Isit possible to change the taqhoma font to verdana
in the comment boxes all at once


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Steve


On Fri, 6 May 2005 16:55:01 -0700, "steve"
wrote:

Is it possible to format the font of the comments in various cells in a
particular sheet at once.Isit possible to change the taqhoma font to verdana
in the comment boxes all at once

Steve


Not sure, but maybe one of the subjects at Debra Dalgeish's site will help.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben Excel MVP

On Fri, 6 May 2005 16:55:01 -0700, "steve"
wrote:

Is it possible to format the font of the comments in various cells in a
particular sheet at once.Isit possible to change the taqhoma font to verdana
in the comment boxes all at once