Creating a global macro

Discussion in 'Microsoft Excel Programming' started by Jack B. Pollack, Jan 10, 2009.

  1. How do I create a macro that is available to all my Excel docs (like
    normal.dot in Word)?
     
    Jack B. Pollack, Jan 10, 2009
    #1
    1. Advertisements

  2. Jack B. Pollack

    Harald Staff Guest

    Start the macro recorder. In the following dialog, field "Store macro in",
    select "Personal macro workbook" and this will be generated for you on
    recording. This is the place to store all general macros you need.

    HTH. Best wishes Harald

    "Jack B. Pollack" <> wrote in message
    news:OXU6%...
    > How do I create a macro that is available to all my Excel docs (like
    > normal.dot in Word)?
    >
    >
     
    Harald Staff, Jan 10, 2009
    #2
    1. Advertisements

  3. Thanks


    "Harald Staff" <> wrote in message
    news:ezo#...
    > Start the macro recorder. In the following dialog, field "Store macro in",
    > select "Personal macro workbook" and this will be generated for you on
    > recording. This is the place to store all general macros you need.
    >
    > HTH. Best wishes Harald
    >
    > "Jack B. Pollack" <> wrote in message
    > news:OXU6%...
    > > How do I create a macro that is available to all my Excel docs (like
    > > normal.dot in Word)?
    > >
    > >

    >
     
    Jack B. Pollack, Jan 10, 2009
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mark L-Z

    Creating Global Macros

    Mark L-Z, Aug 5, 2003, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    329
    Mark Leone-Zwillinger
    Aug 5, 2003
  2. CLR

    Global macro insertion

    CLR, Oct 11, 2003, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    287
  3. Deb
    Replies:
    2
    Views:
    938
    steve
    Oct 16, 2003
  4. Angus Comber
    Replies:
    1
    Views:
    450
    Gord Dibben
    Nov 24, 2003
  5. Sebastian_var

    Creating Global excel macros

    Sebastian_var, Feb 10, 2004, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    443
    Gord Dibben
    Feb 10, 2004
  6. petros89

    Creating a macro which presses a button containing a recorded macro

    petros89, Oct 5, 2005, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    403
  7. Guest
    Replies:
    1
    Views:
    7,032
    Nigel
    Nov 1, 2006
  8. Replies:
    2
    Views:
    190
    Jim Cone
    Jul 9, 2007
Loading...