Making the macro available

The next set of steps makes executing this procedure an easy task:

1. Activate Excel.

2. Right-click a toolbar and select Forms from the shortcut menu.

Excel displays its Forms toolbar.

3. Use the Forms toolbar to add a button to the worksheet: Click the Button tool and drag in the worksheet to create the button.

The Assign Macro dialog box appears.

4. Assign the GetData macro to the button.

5. Edit the button's caption so that it reads Data Entry.

0 0

Post a comment