Link to home
Start Free TrialLog in
Avatar of Wicklunda
Wicklunda

asked on

Excel 2007/Vista Ignoring VBA Breakpoints, Watches

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.
Avatar of Wicklunda
Wicklunda

ASKER

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.
Avatar of Rory Archibald
Do you have any other add-ins installed on the Sony that might be interfering?
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.
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.