General use of Excel Macros (2002/SP3)

Topic

New Reply

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?

Reply | Quote

Replies

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.

Reply | Quote

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

http://www.jkp-ads.com/articles/distributemacro00.asp%5B/url%5D

Reply | Quote

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

Reply | Quote

Any question is welcome here. Enjoy the read.

Reply | Quote