Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: distributing macros

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've posted this a couple times...
    I'm trying to distribute some macros so that all users will be able to use them easily.
    What is the best way to do this?
    Someone mentioned an add-in but I'm not sure how to do that...I saved the modules in an add-in and installed the add-in but can't run the macros.
    Need help!!!!

  2. #2
    Guest

    Default

    Put the Marcos in the workbook you distribute

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The problem is, when they run the reports, it launches another excel session with the text file displayed. They would need to then open the other workbook with the macros in it or I could have them copy the macros to their personal macro workbook...but I'm trying to see if there is a more efficient way because these are not technical users.
    Also it would complicate updating the macros.
    I guess I could write a macro to install the macros...

Some videos you may like

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
  •