Am I missing something ?
I'm writing some very simple VBA in Office 2010 - tinkering with powerpoint at the moment
When I run the code and its correct then its all fine - what I find really irritating and takes up a lot of my time is debugging.
When I've wriitten code in the past and there was an error then the program would stop - a message box would appear explaining the error, the code would 'break' and the code window would appear with the offending line highlighted in yellow. I liked this !
Now when an error occurs in Office (Powerpoint - but it think its the same with all apps), there is no message box, the code does not 'break' and no code window or highlight appears. The only indication that there is a problem is that the expected actions do not happen, it seems that errors are silent - this makes tracking down the source of problems very tricky indeed,
Can Office 2010 VBA be made do show errors the way previous versions used to ?
I've gone to Tools->Options->General on the VBA screen and set 'Break on all Errors' - but without any affect.
Yesterday I has a problem with a badly formed filename - a run-time error - it took me 3hrs to find out what the problem was, once I'd located the issue it only took a couple of seconds to fix it - I need to work more productively and be able to locate errors more efficiently.