Go into the macro and put a breakpoint on the first active statement, then
your code will stop running at the breakpoint and you can use the F8 key to
single step your way through the code afterwards. You can put a breakpoint
on any active statement by clicking the vertical gray bar to the left of
your code... a red dot will appear and the statement will be highlighted in
red to signal the breakpoint for that line.

--
Rick (MVP - Excel)


"Steven" wrote in message
...
I have a Command Button on my Standard Menu. It has an Assigned Macro and
the macro is not functioning the way I want it to. How can I tell it to
Step
Into when it first opens the file when I click the Button on the Menu.
That
is the only way I will be able to tell what is going on because after that
other variables have been set so I cannot just go run the macro after the
file has opened.

Thank you,

Steven