Here it is in its entirety for your review. I must have done something wrong when combining the scripts. Also, when I view the properties of the comment it doesn't show that it's been changed from the default to move but don't size. Unfortunately, the font did not change to Calibri and the first line isn't a red color. Set it to a keyboard shortcut of Ctrl + TĬan someone assist with modifying this macro? Thank you in advance for any and all help!.Set it to move but don't size with cells.Choose Black for the font color for all remaining text.Choose Red for the font color on the 1st line only.Run for only one cell instead of all cells in a worksheet.It would be perfect if it could just include these additional features: This is a fantastic script in that it sets the width of the comment and then auto adjusts for the height base on the amount of text. 'Width of 150 gets me as close to 9.26cm as feasible In turn I find myself doing the same activity over and over again to format them which led me to discover this auto formatting macro:įor Each M圜omments In ActiveSheet.Comments Some comments are formatted perfectly whereas others need resizing. A large part of my workday involves reviewing worksheets containing comments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |