| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying format for multiple comments in a workbook
Is it possible to mass modify the format for multiple comments (or all
comments) in a workbook? Or do you have to modify every comment individually? Thnx. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Modifying format for multiple comments in a workbook
For a given worksheet:
Sub Verd() Dim C As Comment For Each C In ActiveSheet.Comments With C .Visible = True .Shape.Select Selection.Font.Name = "Verdana" .Visible = False End With Next End Sub -- Gary''s Student - gsnu200849 "rmc" wrote: Is it possible to mass modify the format for multiple comments (or all comments) in a workbook? Or do you have to modify every comment individually? Thnx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected Workbook, no comments? | Excel Worksheet Functions | |||
| Modifying multiple cells crash | Excel Discussion (Misc queries) | |||
| Format multiple comments | Excel Discussion (Misc queries) | |||
| comments in shared workbook | Excel Discussion (Misc queries) | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
Linear Mode
