chọn chế độ xem trong hộp thoại Custom Xem, và nhấp vào nút và unfreezing Sử dụng một trong những kỹ thuật này để giữ của bạnBắt một cái nhìn tốt hơn ở WorksheetTùy chỉnh của riêng của bạn xemTinh chỉnh Bảng tính của bạn | Chapter 6 Automating Tasks with Macros ỉn This Chapter Understanding what a macro is Displaying and hiding the Developer tab Examining macro security issues Recording running and editing a macro Placing a macro button on the Quick Access toolbar his brief chapter explains how macros can make your work a little easier. I describe how to display the Developer tab on the Ribbon record a macro run a macro and edit a macro. I also look into macro security issues and show you how to place a macro button on the Quick Access toolbar. What Is a Macro A macro is a set of command instructions recorded under a name. When you activate a macro the program you re working in carries out the instructions in the macro. Macros help automate repetitive and complex tasks. Instead of entering commands yourself the macro does it for you and it enters the commands faster and more efficiently. Instead of reaching into several dialog boxes to get a task done you can run a macro and let it do the work. Not that you necessarily need to know it but playing a macro involves running command sequences in Visual Basic for Applications VBA a programming language built into all the major Office 2010 applications. Behind the scenes the application you re working in executes VBA code when you run a macro. Displaying the Developer Tab Before you can run a macro or do anything in the wonderful world of macros you must display the Developer tab. Figure 6-1 shows the Developer tab in PowerPoint. Follow these steps to display or remove this tab 710 Managing the Macro Security Problem Figure 6-1 The Developer tab in PowerPoint . 1. On the File tab choose Options. You see the Options dialog box. 2. Go to the Customize Ribbon category. 3. On the right side of the dialog box select the Developer check box. 4. Click OK. Managing the Macro Security Problem A macro is a little and sometimes not so little computer program in its own right. As such macros can contain computer viruses. When you run a macro in a .
