how to change font size on calender
how can i change all the numbers font size on calender after downloaded to
excel |
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 |
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 |
All times are GMT +1. The time now is 12:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com