USING MICROSOFT EXCEL
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: -If you want to copy macros from your personal workbook to another workbook or vice versa, you can do so in the Visual Basic Editor (VBE). You can start the Visual Basic Editor in Excel by clicking Visual Basic in the Developer tab.
Detailed explanation-3: -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-4: -In the Save As box, in the Save as type list box, choose Excel Macro-Enabled Workbook (*. xlsm).