ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting Kicked out of Debug mode (https://www.excelbanter.com/excel-programming/390061-getting-kicked-out-debug-mode.html)

J Streger

Getting Kicked out of Debug mode
 
I just received my copy of Office 2007. Pop the clutch, give the tranny a
spin and *crash*, my sheet doesn't work as intended. OK I expected as much.

So I start to step through the code and get to
Sheets(name).shapes(Shapename).Delete and to my shock, I am kicked out of
debug mode. (You know that message that says you cannot step through the code
anymore). Now I am used to this with Sheet deletions, but now shapes too? Did
they use a sub-par debugger this go around? And is there any way to get
around this, as debugging around this problem is a royal pain in the you know
where? I tested in 2003 and I can step through shape deletions fine.

It actually seems that the shapes collection took a hit of change, since I
noticed my sheet, which uses a lot of shapes as buttons, has VBA controls
getting renamed and moved as shapes. *sigh* So any solution to stopping this
debug kicking issue?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003



All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com