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?
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?
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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
And how do I create an adsin? (did you mean an addin?)
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
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Gracias, es justo lo que necesito