| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting comments with shared workbook
Great! Thanks!
"Sheeloo" wrote: To fix the proble assign this macro to a button and use it whenever needed. It will work on comments on the active sheet; [Adapted from http://www.contextures.com/xlcomments03.html#Format] Sub ReformatComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments With cmt.Shape.TextFrame.Characters.Font .Name = "Arial" .Size = 14 .Bold = False .ColorIndex = 5 End With Next End Sub -- Always provide your feedback... "Joyce D" wrote: I have a shared workbook with formatted comments (type formated in larger point size - so easier to read). Every time I save the workbook (shared) and go back into it the size of the type returns to the smaller point size. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Comments In A Shared Workbook | Excel Discussion (Misc queries) | |||
| Comments disappear in shared workbook | Excel Discussion (Misc queries) | |||
| Loosing comments in a shared workbook | Excel Discussion (Misc queries) | |||
| comments in shared workbook | Excel Discussion (Misc queries) | |||
| my comments are disappearing from a shared excel workbook | Excel Worksheet Functions | |||
Hybrid Mode
