use of add-in

D

dan

Hi, I have a workbook with a macro in it. I have the workbook open, do
a save as, and save it as an add-in in my add-in directory. I then go
to Tools>Add-ins, and put a check next to my Add-in. I hit okay.

If I open another workbook and go into the VB editor, it is listed on
the left side in the Project box.

My question is: How do I use this? It is a simlpe macro I wrote to do
some calculations. I want to be able to go under a menu and hit an
option to run the macro. There is nothing under the Tools Menu
referring to my add-in. Help? Thanks!
 
G

Gord Dibben

Dan

Macros in Add-ins do not show up in the Tools>Macro>Macros dialog.

You can type in the macroname and "run" or better yet, create a button on a
Toolbar and assign the macro to that button.

To place a button on a Toolbar...Tools>Customize>Commands>Macros.

Drag the smiley-face button to your Toolbar.

Right-click and "Assign Macro". Select TOGGLECENTERACROSS and OK

Note: when you right-click you will also see "Change Button Image". There are
a bunch of button faces to pick from if you don't like smiley.

OR create a shortcut key combo to run the macro.


Gord Dibben MS Excel MVP
 
B

Bob Phillips

Just type it in the macro box, like 'my addin.xla'!macroname

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top