Shared Macro

  • Thread starter Thread starter Rajesh Sharma
  • Start date Start date
R

Rajesh Sharma

Hi
I have created a macro with Excel 2000. My associates and myself will be
creating spreadsheets and will need to have access to that macro. How
can I make it that I can run from another spreadsheet as well as several
people having access to the macro ?

Please revert at the earliest.

Warm regards,
Rajesh
 
see
http://office.microsoft.com/assistance/2002/articles/xl_RunAMacroWhenExcelSt
arts.aspx and
http://office.microsoft.com/assistance/2002/articles/pwPersonalXLS.aspx for
an overview of running macros automatically when xl starts. For your
particular question, I'd probably recommend you save the wb in which the
macro is located as an add-in, place the add-in on a shared drive, and have
everyone interested in running your macro just activate the add-in. When you
activate the add-in, the instructions specified in the underlying wb's code
will run, essentially giving you what you're looking for. Placing the add-in
on a shared/central site gives you the option of modifying the code as
needed. If you're confidend that the code won't change over time, you can
also create a stand-alone add-in and distribute the file - this would allow
people who aren't connected to your network to use the add-in as well.

HWH
 
Back
Top