Click the Office button, and then click Excel Options.
In the left pane, click Popular.
Select the Show Developer tab in the Ribbon.
Click the Developer or View tab.
Click the Macros button.
Click the macro you want to debug. Click Step Into.
The Microsoft Visual Basic window opens.
Click the Debug menu, and then click Step Into to proceed through each action.