Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using some recorded as well as written macro and want all to save in single location. My queries are :

    1. Is it possible? If yes, how can it be done?
    2. Is it "must to do" to open that file everytime?
    3. Sometime macro assigned files sent to other user. Will they be able to run the macro on their system?

    Thanks in advance as it is going to be solved within no times.

    Regards
    Prasad
    Regards
    Prasad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you want to be able to use a macro in all your workbooks, you can store it in your personal macro workbook Personal.xls. You can also copy existing macros into Personal.xls, in the Visual Basic Editor.
    See Legare Coleman's Personal.xls Tutorial.
    Macros stored in Personal.xls will only be available to you, not to other users.

    If you want to make a set of macros available to other users, you can store them in an Excel add-in (.xla file). See Pieterse's series of articles Create Addins. Other users can install the add-in in their XLSTART folder, then activate it through Tools | Add-Ins...

    If a macro needs to be available only in a specific workbook, you should store it in that workbook. If you send the workbook to others, they will be able to use the macros stored in the workbook too.

  3. #3
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='780622' date='19-Jun-2009 10:31']If you want to be able to use a macro in all your workbooks, you can store it in your personal macro workbook Personal.xls. You can also copy existing macros into Personal.xls, in the Visual Basic Editor.
    See Legare Coleman's Personal.xls Tutorial.
    Macros stored in Personal.xls will only be available to you, not to other users.

    If you want to make a set of macros available to other users, you can store them in an Excel add-in (.xla file). See Pieterse's series of articles Create Addins. Other users can install the add-in in their XLSTART folder, then activate it through Tools | Add-Ins...

    If a macro needs to be available only in a specific workbook, you should store it in that workbook. If you send the workbook to others, they will be able to use the macros stored in the workbook too.[/quote]


    Thanks Hans for advise. It is exactly what I was expecting. No use to creat personal macro book.
    Regards
    Prasad

Posting Permissions

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