Stop Statement ignored in VBA

[gunnark]

A colleague asked me to test one of his Excel-projects, a medium sized Workbook with 4 code modules and 6 user forms. The first thing I did was to put a Stop statement in the beginning of the Workbook_Open Sub, saved the Workbook and closed it. Upon reopening the Workbook I’d expected the Stop statement to throw me into debug mode in the Workbook_Open Sub, but it didn’t. I replaced the Stop statement with a Msgbox and resaved the workbook and closed it. When I reopened the workbook the Msgbox showed up. I once again put Stop statement in the code on the line after the Msgbox resaved the workbook and closed it. When I reopened the workbook the Msgbox showed up but the Stop statement was ignored. What’s happening? Isn’t a Stop statement unconditional? I’m running Excel 2003 on a computer running XP with SP2.

//Gunnar[/b]

 

[OHIOCOWBOY]

I tried to duplicate your results -
When I put STOP as the first line of code it does as you expected, enters debug mode. I'm using Excel 2000 and Windows XP Pro. Maybe it's unique to Excel 2003? I uninstalled Excel 2003 due to a few problems I was having with it.

 

[OHIOCOWBOY]

I tried to duplicate your results -
When I put STOP as the first line of code it does as you expected, enters debug mode. I'm using Excel 2000 and Windows XP Pro. Maybe it's unique to Excel 2003? I uninstalled Excel 2003 due to a few problems I was having with it.

 

[Juan Pablo González]

Mhm, is the code protected ?

 

[gunnark]

Yes, the code is protected, but I ran it in unprotected mode. I should also have mentioned that in all my own projects the Stop statement in the Workbook_Open Sub works as expected.

//Gunnar

 

[gunnark]

Many thanks Juan Pablo you saved my day.

Regards,
Gunnar