VBA AddIn reference in Excel X for Mac

G

Guest

I have installed the Analysis Toolpak and Analysis Toolpak - VBA on my Power
PC G4 using Excel X for Mac. I have included one of the addin functions in a
macro that starts upon opening of the workbook. Before I put the addin in my
code, I had no problems with the macro starting when the workbook was opened.
Once I put that in, Excel hangs and crashes upon opening the workbook. I
added AddIns("Analysis Toolpak - VBA").Installed = True to the open event,
but the workbook still crashed. Either way, Excel isn't recognizing the
AddIn properly until I close the macro and restart it. It seems to work ok
if I don't start the macro with the open event. Any ideas on how I can get
Excel not to crash and the AddIn function to be recognized upon starting the
macro with the open workbook event? Thanks!
 
J

JE McGimpsey

I can't reproduce that in either XLv.X or XL2004. What ATP function are
you using? Also, it might help if you posted your Workbook_Open code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to enable the analysis toolpak VBA addin on entering a workbook?? 2
Excel VBA 2
Do I need DLL or COM Addin, Excel Addin 1
Custom Addin Reference Crashes Excel 6
Update Links, Scheduled Tasks and UDFs 2
Analysis ToolPak Not Working in Browser mode 3
Call an addin Macro from Workbook_Open event 2
using a function in an addin in my vba code 2

Top