Sharing Excel Macros across files

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

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

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

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