Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to change font size on calender
how can i change all the numbers font size on calender after downloaded to
excel |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to change font size on calender
select a cell and pull-down:
Format Cells... Font and set the size. This will only affect your entries, not the template. -- Gary's Student "Bert" wrote: how can i change all the numbers font size on calender after downloaded to excel |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to change font size on calender
Bert
Most of the Calendars from the Template Gallery have the day numbers inside individual Text Boxes. You can manually select these one by one and change the font size or use a macro to cycle through each box. To write specific code I would have to know which Calendar you have downloaded. For the 2005 12 month per page calendar this code will work. Sub Change_Font() Columns("B:H").Select ActiveSheet.DrawingObjects.Select For Each TextBox In Selection With TextBox.Characters(Start:=1, Length:=2).Font .Name = "Comic Sans MS" .FontStyle = "Regular" .Size = 14 .ColorIndex = xlAutomatic End With Next Range("E3").Select End Sub Gord Dibben Excel MVP On Tue, 20 Dec 2005 05:21:02 -0800, "Bert" wrote: how can i change all the numbers font size on calender after downloaded to excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the font color based on results of an IF stateme | Excel Worksheet Functions | |||
Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
drop-down menu font size | Excel Discussion (Misc queries) | |||
How do I change default font for all new comments in Office 2003? | Excel Discussion (Misc queries) | |||
Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel |