Setting up macros
Setting up macros
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Setting up macros

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    England
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    Guest

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com