Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 15

Testing the macro

Оглавление

Before you recorded this macro, you set an option that assigned the macro to the Ctrl+Shift+N shortcut key combination. To test the macro, return to Excel by using either of the following methods:

 Press Alt+F11.

 Click the View Microsoft Excel button on the VB Editor toolbar.

When Excel is active, activate a worksheet. (It can be in the workbook that contains the VBA module or in any other workbook.) Select a cell and press Ctrl+Shift+N. The macro immediately enters your name into the cell.

Excel Macros For Dummies

Подняться наверх