Step Into Macro when file opens
 

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

Step Into Macro when file opens
 

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

Step Into Macro when file opens
 

Rick,

Thank you for the response. Question: But I cannot put a breakpoint and
then close the file and then and have it break at that point, correct? ie If
I close the file it will remove the breakpoint. How can I keep the
breakpoint even when I close the file so when I open the file it will stop on
that breakpoint when the file is first opened. Note: I am opening the file
by a command button on the menu bar with an assigned macro in the file. That
macro is where I want to start stepping into the macro when the file first
opens.

Thanks,

Steven

"Rick Rothstein" wrote:

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

Step Into Macro when file opens
 

Good point. Then you should be able to insert a Stop statement before the
first active statement you want to break at. The Stop statement causes the
same kind of break that the "red dot" method does and should be able to be
saved with the macro.

--
Rick (MVP - Excel)


"Steven" wrote in message
...
Rick,

Thank you for the response. Question: But I cannot put a breakpoint and
then close the file and then and have it break at that point, correct? ie
If
I close the file it will remove the breakpoint. How can I keep the
breakpoint even when I close the file so when I open the file it will stop
on
that breakpoint when the file is first opened. Note: I am opening the
file
by a command button on the menu bar with an assigned macro in the file.
That
macro is where I want to start stepping into the macro when the file first
opens.

Thanks,

Steven

"Rick Rothstein" wrote:

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