Stepping through VBA code in Excel

[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

 

[Guest]

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.

 

[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.