WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
Using Excel Add-Ins to Share VBA Code
Part one of a four-part series of blogs

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.

  1. Sharing Code across Workbooks using Add-Ins (this blog)
  2. Useful Examples of Code to Share
  3. Creating an Add-In
  4. Using Add-In Functions

This blog is part of our Excel VBA online tutorial.  Wise Owl also run excellent classroom-based VBA courses!

Posted by Andy Brown on 05 March 2012

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.

 

  1. Sharing Code across Workbooks using Add-Ins (this blog)
  2. Useful Examples of Code to Share
  3. Creating an Add-In
  4. Using Add-In Functions
This blog has 0 threads Add post