DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor
|
|
|
Use the Record Macro button on the Developer tab
|
|
|
Use the Add-Ins button on the Developer tab
|
|
|
Open the Visual Basic Editor and type RUN COPYMACROS in the Project Explorer window
|
Detailed explanation-1: -Open both the workbook that contains the macro you want to copy, and the workbook where you want to copy it. On the Developer tab, click Visual Basic to open the Visual Basic Editor., or press CTRL+R . In the Project Explorer pane, drag the module containing the macro you want to copy to the destination workbook.
Detailed explanation-2: -But what if you want to use the macro in other workbooks? To make your macros available every time you open Excel, you can create them in a workbook called Personal. xlsb. That’s a hidden workbook stored on your computer, which opens in the background every time you open Excel.
Detailed explanation-3: -In the Save As box, in the Save as type list box, choose Excel Macro-Enabled Workbook (*. xlsm).
Detailed explanation-4: -How To Open The Visual Basic Editor In Excel. You can open the VBE using either of the following methods: Click on “Visual Basic” in the Developer tab of the Ribbon. Use the keyboard shortcut “Alt + F11”.