tailieunhanh - Introduction to using macros in Microsoft Excel 2003 phần 2

Một phông chữ máy đánh chữ được sử dụng cho những gì bạn nhìn thấy trên màn hình. Một font máy đánh chữ in đậm được sử dụng để đại diện cho các nhân vật thực tế mà bạn gõ vào bàn phím. Một font máy đánh chữ nghiêng được sử dụng cho các hạng mục như tên tập tin mà bạn nên thay thế với các trường hợp cụ thể. | 11 Drag that Smiley Face button to your new Macros toolbar. 12 Right-click on the Smiley Face button. Note that the shortcut menu includes options to change the button s image and edit it. 13 Click on Assign Macro. 14 In the Assign Macro dialog box select the Address_abs macro and click OK. 15 In the Customize dialog box click on Close. Guide 39 Introduction to using macros in Microsoft Excel 2003 7 Note A custom toolbar belongs to the workbook that is active when the toolbar is created. Now try using the button you created 1 Clear the cells containing your name and address on Sheet2. 2 Click on the Smiley Face button on your custom toolbar. Your name and address should appear starting in cell B3. Running a macro from a command on one of Excel s menus A menu command can be added to a menu so that selecting that new command will run a macro. As an example a new command called Work Address can be put on a new menu called Macros on the standard toolbar as follows 1 Make sure that the workbook containing your macros is open. 2 Insert a new worksheet using Insert Worksheet probably Sheet4 . 3 From the Tools menu select Customize. 4 In the Customize dialog box select the Commands tab. 5 Scroll down the items in the Categories box and select New Menu. 6 Point to the New Menu item in the Commands box and drag it to the standard toolbar just to the right of Help. 7 Right-click on the New Menu item on the menu bar. 8 Guide 39 Introduction to using macros in Microsoft Excel 2003 8 Select the text in the Name box and type Macros 9 Press the Enter key. The ampersand in front of the M indicates that M is the accelerator key for that menu the underlined letter . Next create a new menu command on the Macros menu 1 In the Categories box in the Customize dialog box still on the screen select Macros. 2 From within the Commands box drag the Custom Menu Item up to the Macros menu and keep the mouse button held down. An empty drop-down menu will appear underneath the command. 3 Drag