software

how can i change all the numbers font size on calender after downloaded to
excelselect a cell and pull-down:

Format gt; Cells... gt; Font and set the size. This will only affect your
entries, not the template.
--
Gary's Studentquot;Bertquot; wrote:

gt; how can i change all the numbers font size on calender after downloaded to
gt; excel
gt;

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(quot;B:Hquot;).Select
ActiveSheet.DrawingObjects.Select
For Each TextBox In Selection
With TextBox.Characters(Start:=1, Length:=2).Font
.Name = quot;Comic Sans MSquot;
.FontStyle = quot;Regularquot;
.Size = 14
.ColorIndex = xlAutomatic
End With
Next
Range(quot;E3quot;).Select
End SubGord Dibben Excel MVP

On Tue, 20 Dec 2005 05:21:02 -0800, quot;Bertquot; gt;
wrote:

gt;how can i change all the numbers font size on calender after downloaded to
gt;excel