Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Macro
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Macro
see
http://office.microsoft.com/assistan...croWhenExcelSt arts.aspx and http://office.microsoft.com/assistan...rsonalXLS.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 "Rajesh Sharma" wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for shared workbook | Excel Discussion (Misc queries) | |||
Macro vs Shared Doc | Excel Discussion (Misc queries) | |||
Macro vs Shared Doc | Excel Discussion (Misc queries) | |||
Shared Workbooks with Macro | Excel Discussion (Misc queries) | |||
Macro error when file is shared | Excel Discussion (Misc queries) |