Out of Scope Errors when exiting Excel
You shouldn't have to use the End button (except in development) or the End
statement ever.
Impossible to say much more without the code, but in general ensure all
object references that will not go out of scope automatically (most do) are
released.
Regards,
Peter T
"Steve McLeod" wrote in message
...
I have worksheets with controls and associated event code. When I exit the
Excel I am getting compiler errors in code that references controls and
other
objects that have gone out of scope while Excel is shutting down. The VBA
code that is flagged as in error is not consistently the same. How do I
get
Excel to shut down without the need to click the "End" button in the VBA
debugger prompt?
--
Pictou
|