Entering Debug after delete sheet
I've never seen this occur after deleting a sheet.
But I have seen a similar message appear "Can't enter break mode at this time"
when I'm adding a control from the Control toolbox toolbar to a worksheet. I
can't step through that line (always????).
So I set a break point right before and after and just run to the next step.
It's almost the same.
(Are you sure it's "debug mode" in the warning message???)
DocBrown wrote:
I have a macro where it's tasks is to delete a WS and copy a replacement from
another WB. When single stepping through the code, after the
Sheets("Lists").delete, VBA will no longer allow me to enter the debug mode.
I get the message "Can't enter debug mode at this time."
Any ideas why this occurs? And how to I enter debug in this code? (other
than debug.print)
In order for the rest of the code to operate correctly, the sheet must be
deleted.
Thanks,
John
--
Dave Peterson
|