Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comment size
I'd like to change the comment size in excel, but do not want to use the
Properties - Appearance - Advanced - Item - Tooltip route. I've seen this on Debra Dalgleish's site - Sub CommentAddOrEditTNR() 'adds TimesNewRoman comment or positions 'cursor at end of existing comment text Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Name = "Times New Roman" .Size = 11 .Bold = False .ColorIndex = 0 End With End If SendKeys "%ie~" End Sub Can I put this in some kind of excel startup file so that all Excel files that I create or edit will have these new comment settings? Thanks for any comments. |
#2
|
|||
|
|||
Comment size
You could add the macro to your Personal.xls workbook, or another file
that you usually have open. Then, add a button to one of your toolbars, and assign that macro to it. When you want to insert a comment, click the toolbar button. Don wrote: I'd like to change the comment size in excel, but do not want to use the Properties - Appearance - Advanced - Item - Tooltip route. I've seen this on Debra Dalgleish's site - Sub CommentAddOrEditTNR() 'adds TimesNewRoman comment or positions 'cursor at end of existing comment text Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Name = "Times New Roman" .Size = 11 .Bold = False .ColorIndex = 0 End With End If SendKeys "%ie~" End Sub Can I put this in some kind of excel startup file so that all Excel files that I create or edit will have these new comment settings? Thanks for any comments. -- 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 | |||
Default cell comment fill color and font size | Excel Discussion (Misc queries) | |||
Comment window size | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
changing comment indicator size or shape | Excel Worksheet Functions | |||
comment indicators should feature lock or pw protect limiting acc. | Excel Worksheet Functions |