Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting the font type for all comments on excel spreadsheets
How can I set the font type and size for all the comments on a whole
spreadsheet. Tahoma is set at present and I want to change to a TT font. I know how to change each comment individually but want to reset the whole sheet. I am using office 2000. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting the font type for all comments on excel spreadsheets
You can try out the below macro. If you are new to macros..
--Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run <selected macro() Sub Macro() Dim sh As Worksheet, objCom As Object For Each sh In ActiveWorkbook.Sheets For Each objCom In sh.Comments With objCom.Shape.TextFrame.Characters ..Font.Name = "TT" ..Font.Size = 10 End With Next Next End Sub If this post helps click Yes --------------- Jacob Skaria "Delquestion" wrote: How can I set the font type and size for all the comments on a whole spreadsheet. Tahoma is set at present and I want to change to a TT font. I know how to change each comment individually but want to reset the whole sheet. I am using office 2000. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting the font type for all comments on excel spreadsheets
If you want to change the font and size for the whole spreadsheet, click on
the upper left corner of the spreadsheet (the blank box between Row 1 and Column A) and it will highlight the whole spreadsheet. Then change your font and size. If you only want to change it for a single column, click on the column number and make your changes. "Delquestion" wrote: How can I set the font type and size for all the comments on a whole spreadsheet. Tahoma is set at present and I want to change to a TT font. I know how to change each comment individually but want to reset the whole sheet. I am using office 2000. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting the font type for all comments on excel spreadsheets
Thanks for the two replies. The one about macros seems a bit complicated for
me Jacob. June thanks I know how to set the font type and size for cells what I want to know is how to change them in the comments that are signified by the red triangle in top right corner of cells. "Delquestion" wrote: How can I set the font type and size for all the comments on a whole spreadsheet. Tahoma is set at present and I want to change to a TT font. I know how to change each comment individually but want to reset the whole sheet. I am using office 2000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My comments on my excel spreadsheets print as black squares why? | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
How do I set default footer setting on excel spreadsheets? | Excel Worksheet Functions | |||
How do I set Excel comments default font size | Excel Discussion (Misc queries) | |||
setting up default font size in comments | Setting up and Configuration of Excel |