Sharing Excel Macros across files

April 7, 2005 at 08:52:41
Specs: Win2k SP4, Pentium 2.8 ghz/515,568 k

Hi All,

With MS Word my VB macros are available in all my documents, not true with Excel Workbooks.

Is there a way to make my Excel VB macros available to multiple workbooks without doing a copy/paste?

Thank You in Advance for Your Help,

Lou


See More: Sharing Excel Macros across files

Report •


#1
April 7, 2005 at 10:21:44

They should be available. Is your macroworkbook in the XLStart folder? Are the macros general enough to run on whatever the active workbook is?

Report •

#2
April 7, 2005 at 11:19:41

Hi Grok,

Thanks for your reply!

Are the macros general enough to run on whatever the active workbook is?
Yes, definately!

Is your macroworkbook in the XLStart folder?
Not sure what you mean by this.
I started a new workbook saved it on a network drive. I wrote a couple of macros and thought that it would be really useful if they were available to other workbooks I may create in the future.

I just Googled macroworkbook and it looks like I can find what I need to set this up.

Thanks

Lou


Report •

#3
April 7, 2005 at 13:58:29

When creating a macro you have the option to save it to the Personal workbook that makes them available all the time for the user.

You can also open the workbook that contains the macro to make it available in other open workbooks.

HTH
Bryan


Report •

Related Solutions

#4
April 7, 2005 at 17:01:23

Thanks Grok and Bryan! I managed to get it working without very much difficulty.

Here are the links I found helpful in case someone else is looking

http://office.microsoft.com/en-us/assistance/HA010872961033.aspx

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B141576



Report •


Ask Question