DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Macro dialog box
|
|
|
The Excel status bar
|
|
|
The Visual Basic Editor
|
|
|
The Message Bar
|
Detailed explanation-1: -By default, when you first open a macro-enabled workbook you’ll see a yellow “SECURITY WARNING” bar appear just underneath the ribbon. Clicking the “Enable Content” button will enable macros. This will trigger any macros that run when the workbook is opened, so don’t click this by mistake!
Detailed explanation-2: -In an Office program, click the File tab. Click Options. Click Trust Center, and then click Trust Center Settings. Click Message Bar.
Detailed explanation-3: -Click the File tab > Info. In the Security Warning area, click Enable Content > Advanced Options. In the Microsoft Office Security Options dialog box, select Enable content for this session, and click OK.
Detailed explanation-4: -On the Developer tab, in the Code group, click Macro Security. To enable the Developer tab, see Show the Developer tab. In the Macro Settings category, under Macro Settings, click the option that you want.
Detailed explanation-5: -Excel macro security protects your computer against viruses that may be passed to your computer via Excel Macros. Macro security has changed significantly between Excel 2003 and Excel 2007.