Excel 2007/Vista Ignoring VBA Breakpoints, Watches

Posted on 2009-12-28
Medium Priority
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
  • 3
  • 2

Author Comment

ID: 26135575
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
ID: 26144783
Do you have any other add-ins installed on the Sony that might be interfering?

Author Comment

ID: 26149438
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

Rory Archibald earned 2000 total points
ID: 26152053
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

ID: 31675165
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.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

571 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