Automatically load an "Add-In"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel template in VB for Math practice in school. The computers are networked. When the template workbook is opened, Excel does NOT remember that the "Add-Ins" have previously been added in

Can anyone please suggest a line of code that I can put in the existing code that will automatically add in certain "Add-Ins" when the workbook is opened

Thank

Bill Hall
 
I am not sure I understand the problem. Loading an add-ins has nothing
to do with opening a workbook or template. Add-ins are loaded (or
unloaded) through Tools | Add-Ins...

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Open both the addin and the workbook that requires the addin.

go to the VBE. select the addin and make sure it has a nice project name (not
VBAProject).

then select the other workbook.
click on tools|References and add a reference to that addin.

Save your workbook. Close excel and try it out (Open your workbook to test!)
 
Back
Top