Debugging a Macro Using Step Mode


If a macro doesn't work exactly the way you want it to, you can fix the problem without re-creating the macro. Instead of recording the macro over again, Excel allows you to debug , or repair, an existing macro, so that you change only the actions that aren't working correctly. Excel's step mode shows you each action in a macro, such as a particular menu command, being executed one step at a time, and it also shows you the programming code corresponding to the action in a separate window called a Module sheet. Using step mode, you can determine which actions need modification, and then you make the necessary changes.

Debug a Macro Using Step Mode


Click the Tools menu, point to Macro, and then click Macros.


Click the name of the macro you want to debug.


Click Step Into.


Click the Debug menu, and then click Step Into to proceed through each action.


When you're done, click the File menu, and then click Close And Return To Microsoft Office Excel.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291 © 2008-2017.
If you may any questions please contact us: