Oh! I forgot about the SHIFT thing!

Good one, Dave

"Dave Peterson" wrote:

I've never seen excel behave this way. (I have the analysis toolpak enabled,
too.)

If you move the code from the thisworkbook module and put it in a general module
(and rename it to Auto_Open()), does that fire?

===
How does that person open the workbook? Is there any shortcut key envolved
(either windows or an excel macro shortcut key???).

If yes, remove the shift key from the shortcut. Holding the shift key down
while opening a workbook will tell excel not to fire the open procedures.





"Sheena N via OfficeKB.com" wrote:

Hi
Thanks for the quick reponse
I removed all code from the Workbook_Open event and placed Msgbox "Test"
there. If the Analysis Toolpak Add In is selected the Msgbox is not
displayed. If the Add In is unselected the Msgbox is displayed.
It looks like if the Addins is selected it does'nt even enter the
Workbook_Open event.

Thanks
Sheena

--
Message posted via http://www.officekb.com

--

Dave Peterson