Workbook_Open not running when Analysis Tool Pack Add-in selected

G

Guest

I have a Workbook_Open macro in the ThisWorkbook module that is not running. If I un-select the Analysis Tool Pack add-in, it runs just fine. How do I get both of these things to work together?
 
T

Tom Ogilvy

This isn't a known problem. I have the analysis toolpak addin selected and
workbook_Open runs fine for me. Perhaps you have something in workbook open
that conflicts with something in the analysis toolpak.

Is this a consistent repeatable behavior - that occurs even after you
reboot? Does it happen with multiple workbooks?

--
Regards,
Tom Ogilvy
Jim Zeeb said:
I have a Workbook_Open macro in the ThisWorkbook module that is not
Click to expand...
running. If I un-select the Analysis Tool Pack add-in, it runs just fine.
How do I get both of these things to work together?
 

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

Slow Analysis Tool Pack 1
Workbook_open not running and Phantom Projects 6
Private Sub Workbook_Open() & Workbook_BeforeClose(cancel As Boolean) 4
Open workbook without running Workbook_Open Event 4
XL97 Private Sub Workbook_Open() Not Working 6
open a workbook without running Workbook_Open macro in E2007 10
Workbook_Open event fails to fire 3
How can I use Analysis Toll Pack functions in VBA? 3

Top