Solved: Making macros available for every excell worksheet

[Ru5ben]

Hi,
I've succesfully wrote my first few macros. Now I want to make them authomatically available for every time I open microsoft excell and not just for the specific workbook where I created them. How is it done?

[Bob Phillips]

Either put the macros in Personal.xls, or create an adsin and add them to that.

The thing to be wary of is to ensure that your macros work upon the correct workbook/worksheet/range, so best to fully qualify them.

[Ru5ben]

And how do I create an adsin? (did you mean an addin?)

[Bob Phillips]

http://msdn.microsoft.com/library/de...ificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/de...xceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/de...slibraries.asp
Add-ins, Templates, Wizards, and Libraries

[Ru5ben]

Gracias, es justo lo que necesito