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

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.

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.

--

Vasant

"Bill Murphy" wrote in message
...
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