Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    General use of Excel Macros (2002/SP3)

    I have created a number of macros that I'm happy with and want to make it available for general use in my department. I have two scenarios relating to the general use and distribution of the macros:

    1) When I start up a new Excel application or workbook I want to be able to have access to the macros. I read about using Worksheet Events but it doesn't seem to be the answer since I don't want to use the original spreadsheet that I created, but rather have the macros available whenever I open a new workbook.

    2) I want my co-workers to have access to the macros without me having to send my original spreadsheet (that contain all macros) to each person. Again, I read about the application of 'add-in', but I'm not sure if that the best way to go about it.

    I'm not sure where to start, so I would like to ask for the best way to handle this?

  2. #2
    Lounger
    Join Date
    Sep 2008
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: General use of Excel Macros (2002/SP3)

    I keep my generally useful macros in my Personal Macro Workbook.
    To distribute them, I'd send a workbook with them in it to my co-workers and let them choose the macros that they find useful.
    An add-in would have to be distributed like a workbook. (i.e. e-mail a file to someone)

    Handling problem situations and how to do updates would depend on how critical your macros are to the job at hand and what resources (including your time) the company is willing to allocate.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: General use of Excel Macros (2002/SP3)

    I'd suggest you to read the pages starting from this one:

    http://www.jkp-ads.com/articles/distributemacro00.asp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: General use of Excel Macros (2002/SP3)

    Thanks all. I'll have to do some more reading before I ask any more questions.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: General use of Excel Macros (2002/SP3)

    Any question is welcome here. Enjoy the read.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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