Setting up macros

[Stuart Little]

Please could anyone advise me on how to set up a macro. I like to use the same font all the time but i have to change the default every time i log on, and also when i download data i have to highlight it all and change it. So is there a way of setting up a macro so that i can just press a button and the font is changed automatically. Fussy I know but please help!!

 

[Paul B]

this will change the font to times new roman
Sub change_font()
With Selection.Font
.Name = "Times New Roman"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
End Sub

To record a Marco go to tools Marco record new Marco, give it a name, what ever you do after this will be record when you are done click stop recording, you can assign the Marco to a button shortcut key or press alt and f8 to run it. Hope this helps
This message was edited by paul b on 2002-03-05 15:47

 

[Guest]

Stuart,

You can also change the "default" font in the Tools>Options>General dialog box. Another method is to save a template named "book.xlt" in your templates folder. Configure the template how ever you like (I change things like font, font size, zoom, default print margins, etc.) and then Excel will use that "book" whenever you open Excel or create a new workbook. You can do the same thing with a sheet ("sheet.xlt").


enjoy

Bariloche