Delet Sheets with out Automation Error
I don't use the End command (not End sub and not end if ...) in code. It ends
the running macro, but doesn't do it gracefully (as you've seen).
rogge wrote:
All of the code is affecting items in the activeworkbook. I don't use code
in this workbook to change objects in another workbook.
Only callbacks (procedures executed from the ribbon) set this boolean
variable.
I am going to ask this resetting question in a separate thread because i
have found that ending the code execution resets the boolean.... please
search for "rogge"
thanks for your help.
"Dave Peterson" wrote:
What kind of code are you using that resets that variable?
Maybe it's better to fix that.
======
But for this situation, I would be surprised (but it's possible), that you
really meant the activeworkbook:
--
Dave Peterson
|