Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
Hello,
Is there a way to step through all the comments in xls file and then autoformat them? -- Thanks in advance, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
Steven,
The following function will auto-size all comments in the active sheet. Perhaps you could adapt it to suit your needs. HTH Function CommentsAutoSizeAll() Dim cmt As Comment Dim cmts As Comments Set cmts = ActiveSheet.Comments For Each cmt In cmts cmt.Shape.TextFrame.AutoSize = True Next End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Comments | Excel Discussion (Misc queries) | |||
comments | Excel Discussion (Misc queries) | |||
comments | Excel Discussion (Misc queries) |