Creating an Excel Add-In

[Guest]

I have a macro that I'd like to make into an Add-In. Can someone direct me
to the procedures I'd need to follow to do this.

Thanks in advance,
Barb Reinhardt

 

[Norman Jones]

Hi Barb,

See:

How to create an add-in file in Excel 2000
http://support.microsoft.com/default.aspx?kbid=211563.


See also Jan Karel Pieterse's comprehensive tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm

 

[Guest]

Hi Barb,
For just one Macro, you may be better off putting it into Personal.xls.
Add-Ins are generally used to contain a small applet.
If you do still want to put your Macro into an Add-In you may like to refer
to a good Excel book - like Excel Bible books by John Walkenbach.
Alok

 

[Guest]

How do I invoke the macro once the add-in has been created?

 

[Guest]

How do I put it in Personal.xls?

Hi Barb,
For just one Macro, you may be better off putting it into Personal.xls.
Add-Ins are generally used to contain a small applet.
If you do still want to put your Macro into an Add-In you may like to refer
to a good Excel book - like Excel Bible books by John Walkenbach.
Alok

 

[Gord Dibben]

Barb

Personal.xls is created the first time you record a Macro using Macro
Recorder.

It is used for making macros available to all open workbooks.

Tools>Macro>Record New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing/copying them into the
Module.

In this case, copy the macro code into the module.

You can do a File>Save from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit Window>Hide.

When you close Excel you will be asked if you want to save Personal.xls. Yes!

It will open hidden next time you start Excel.

NOTE: when assigning macros to buttons or menu items you will have to precede
the macro name with Personal.xls.

i.e. Personal.xls!macroname

An alternative to Personal.xls is to create an add-in(*.xla) with your macros
in it and load it through Tools>Add-ins.

The benefit of this is that you don't have to precede the macro name with the
filename.

A disadvantage is that you will not see the macros in the Tools>Macro>Macros
dialog.


Gord Dibben Excel MVP

 

[Norman Jones]

Hi Barb,

Did you look at the suggested tutorial?

In Section 1, Jan Karel discusses the creation of a macro in a Personal.xls
workbook.

In Sections 3 and 4, Jan Karel shows how to create a menu or toolbar for
the addin's macros.