LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking debug mode in a macro Megadrone Excel Worksheet Functions 1 November 30th 06 10:32 PM
Show value of variable on mouse-over in debug mode - bug? Chet Shannon[_4_] Excel Programming 0 January 9th 06 08:52 PM
Get in DEBUG mode on workbook open Anthony Fok[_2_] Excel Programming 5 July 28th 05 06:30 PM
Debug Step vs Run Mode Arthur[_3_] Excel Programming 3 November 9th 03 05:03 PM
Mysterious debug mode Shunt Excel Programming 0 August 7th 03 02:35 PM


All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"