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:
    266
    Mark Leone-Zwillinger
    Aug 5, 2003
  2. Sebastian_var

    Creating Global excel macros

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

    Creating a macro which presses a button containing a recorded macro

    petros89, Oct 5, 2005, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    323
  4. Guest
    Replies:
    1
    Views:
    4,649
    Nigel
    Nov 1, 2006
  5. Replies:
    2
    Views:
    164
    Jim Cone
    Jul 9, 2007
Loading...

Share This Page