Dear Sheena:

First you need to check the obvious: is the Workbook_Open event really
failing to start? I had a problem like yours with the RefEdit control; you
cannot place a breakpoint in it because it will be ignored, yet the event
will run correctly. The same applies with errors and the default error
handler (On error goto 0). Try placing a msgbox "Test" on the very first line
of your code for Workbook_Open event. If it works, then you will know that
the problem is not in the event; it's in the default error handler. If you
have a problem with the default error handler, one workaround to see if you
have an error in your code (perhaps because the difference between the
versions) is to use the On error goto err_handler option at the beginning of
your code (after the Workbook_Open declaration), and adding
err_handler:
msgbox err.description
to the bottom of your code.

Hope that helps.

G.Morales

"Sheena N via OfficeKB.com" wrote:

Hi
My user has Excel 2002 SP2 on his machine. I developed a spreadsheet on
Excel 2002 SP3. On my machine it works fine irrespective of whether the
Analysis Toolpak is selected or not. But when the user opens it on his
machine the Workbook_Open event does not get fired. If Analysis toolpak is
unselected the spreadsheet works fine. The Macro security is set to low.
Any suggestions on how to get the event to work with the Analysis Toolpak
selected. Thanks