If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to change font size on calender
how can i change all the numbers font size on calender after downloaded to
excel |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I change the font size in the message listing in Outlook? | squinting user | General Discussion | 1 | November 1st, 2005 08:50 PM |
How do I permanently change font size in outlook html ? | Not Dave | General Discussion | 0 | October 25th, 2005 03:35 PM |
Cannot change font in Word 2003 | stevemalee | General Discussion | 0 | August 16th, 2005 06:33 PM |
How do I change the font size of captions? | Ken Roller | General Discussion | 3 | May 17th, 2005 12:20 AM |
How do I change the font size on folders? | KathyM | General Discussion | 0 | February 15th, 2005 01:39 PM |