PDA

View Full Version : Solved: Making macros available for every excell worksheet



Ru5ben
03-09-2008, 10:29 AM
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
03-09-2008, 10:31 AM
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
03-09-2008, 10:49 AM
And how do I create an adsin? (did you mean an addin?)

Bob Phillips
03-09-2008, 10:57 AM
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrbuildingapplicationspecificaddins.asp
Building Application Specific Add-Ins

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrexceladdins.asp
Excel Add-Ins

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovraddinstemplateswizardslibraries.asp
Add-ins, Templates, Wizards, and Libraries

Ru5ben
03-09-2008, 11:16 AM
Gracias, es justo lo que necesito