Implementing an Excel 2007 AddIn
Posted on 2011-09-17
I've created several VBA subroutines that I want to be able to run from within multiple workbooks.
I copied all of the code into a new workbook, and saved the file as a .xlam file.
I went into the Excel Options, selected the Addins, found my xlam file and added it. But I don't see any way to call these subroutines. I thought they would show up as drop-downs or options in the Add-Ins tab, but dont' see them.
In the workbook I was developing in, I just called the subroutines from the Click event of a command button, but would prefer not to have to put the command buttons on each workbook that would use this code.