Excel 2007/Vista Ignoring VBA Breakpoints, Watches

Posted on 2009-12-28
Last Modified: 2012-05-08
I am developing an XLM with custom code. When I first open it in the IDE I can step or set breakpoints.

After the first run though, pressing F8 becomes the same as F5 and it ignores all watches and runs all the way through. Esc key works to break but it just stops the code and the normal dialog doesn't show up.

I have tried rebooting and powering all the way down. Same thing: works the first time only. I tried saving the XLM into old XLS format, same thing: 1 time only.
Question by:Wicklunda

    Author Comment

    I tried it on another PC running Vista/Excel 2007 and it work fine so this appears to be machine specific. This is a Sony Vaio laptop, 4 gb ram, Vista Home premium 64 bit SP2. The machine it worked on was Dell desktop, 1 gb Ram, Vista Home premium 32 bit SP2.
    LVL 85

    Expert Comment

    by:Rory Archibald
    Do you have any other add-ins installed on the Sony that might be interfering?

    Author Comment

    I do have two addins on the Sony that aren't on the Dell. One is a PDF maker and the other an Excel untility called PUP 7 by John Walkenbach. Those have not caused an issue on my work XP machine and as far as I can remember the step mode has worked on this machine in the past.
    LVL 85

    Accepted Solution

    I can't think of an Excel setting that would cause that. There have been a couple of really buggy MS updates recently that have caused all sorts of problems, so that might be the cause.
    Might be worth running Code Cleaner on the file just in case though.

    Author Closing Comment

    The issue seems to have gone away although I cannot pinpoint what did it. I want to log it so there is a record in case others have a similar incident.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now