Stepping through VBA code in Excel

B

Bill Murphy

What is the best way to set breakpoints and step through code in Excel VBA?
To edit the VBA code I have to tell Excel to disable macros when I open a
spreadsheet, and then I can't run the code to step through it.

Bill
 
C

chris

Here is something i use all the time: Sto

Put Stop as the first executable line in the code you want toi step through. The code will cease execution and allow you to step through.
 
V

Vasant Nanavati

Why do you have to disable macros?

If you need to disable only the startup macros, keep the Shift key depressed
while the workbook is opening.
 
Top