Getting Started With Excel Macros

When you use shortcut keys for macros in other workbooks, you may not always receive the correct macro to execute. Excel does not let you assign a shortcut key if a macro in your current workbook uses the shortcut, but it does not check unopened workbooks. If you open workbooks with the same shortcut key, Excel does not know which macro to execute when you select the shortcut. If you use the shortcut keys for a macro and do not receive the anticipated results, you need to verify what you assigned to the shortcut keys.

If you find that the shortcut keys are the same as another available macro, you can reassign a shortcut key to a macro from the Macro dialog box by clicking the macro and then clicking Options to display the Macro Options dialog box. Type the desired shortcut key and click OK. To make the shortcut key modification permanent, save the workbook that contains the macro. Keep in mind, that you may find it easier to simply change a lowercase shortcut to uppercase, or vice-versa.

LAUNCH A KEYBOARD SHORTCUT

LAUNCH A KEYBOARD SHORTCUT

—0 Click the cell where you want the macro to execute.

0 Press Ctrl and the shortcut key to activate the macro.

m

File Edit View Insert

Format Tools Data

Window Help

Type

question For help -■ _

£jxj e x

I □

g? a 3

à say » %

& 2 -

èi l\ 001 100% \ ® T

I Arial

10 - B I U

% , too ÎF

* - A - t

H3

r-

=SUM(B3:G3)

A

B

C

D I E

F I G

H

1

J

K

1

Office Expenses

2

Rent

Advertising

Phone

ISP

Parking

Misc.

3

$350.00

$400.00

$200.00

$110 00

$50.00

$175.00

$1,285.00

4

February

35C

350

240

110

50

145

5

March

350

550

310

110

50

123

6

April

350 795 250

110

50

211

7

May

350 800 245

110

50

345

8

June

350 795 310

110

50

149

9

July

350 BOO 340

110

50

190

10

August

350 910 215

110

50

256

11

September

350 845 400

110

50

298

12

October

350 765 450

110

50

245

13

November

350 900 4G5

110

50

405

14

December

350 1005 500

110

50

605

15

I

19

20

21

22

23

24

25

—0 Click the cell where you want the macro to execute.

0 Press Ctrl and the shortcut key to activate the macro.

-■ The selected macro executes and makes the appropriate changes to the worksheet.

0 To run the macro again, repeat steps 1 and 2.

0 0

Post a comment