Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to run code to change Excel comment font
This is what I have found so far, '====================== 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 '======================== Some questions. 1. What is this? 2. How do I use this? -- lucrosus |
#2
|
|||
|
|||
This is a macro that changes the font and font size in comments in the
active workbook. A couple of periods have fallen off though -- you can see the original code he http://groups.google.com/groups?hl=e...turesXSPAM.com There are instructions here for copying the code to your workbook: http://www.contextures.com/xlvba01.html David McRitchie has instructions for getting started with macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm lucrosus wrote: This is what I have found so far, '====================== 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 '======================== Some questions. 1. What is this? 2. How do I use this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Excel should allow me to change text color & font within tabs. | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) |