If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.
- Sharing Code across Workbooks using Add-Ins (this blog)
- Useful Examples of Code to Share
- Creating an Add-In
- Using Add-In Functions
Posted by Andy Brown on 05 March 2012 | 2 comments
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Sharing Code across Workbooks using Add-Ins
Often you'll create a bit of code so useful that you want it to be available whenever you're using Excel. By far the best way to do this is to create an add-in. This blog shows:
- 3 examples of code that you might want to share between workbooks;
- How to create an add-in; and
- How to reference an add-in that you've created in code.
Let's start with why you might want to create an add-in, by looking at 3 examples of useful functions to share.
This blog has 2 comments
Hi Andy ,
Thank you for a detailed and clear explanation.
To be honest, no - I wasn't aware of this. Try these steps for releasing add-ins - I'd be grateful if you could comment here on your findings.
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.