High School

What steps will change an existing macro? Use the drop-down menu to complete the steps.

1. Go to the tab on the ribbon.
2. In the Macros group, click.
3. Click, which will open the VBA editor.
4. Find and change the code, then Save and Close.

Answer :

Answer:

Go to the

✔ View

tab on the ribbon.

In the Macros group, click

✔ View Macros

.

Select the name of the macro you wish to alter.

Click

✔ Edit

, which will open the VBA Editor.

Find and change the code for the macro.

From the File drop-down menu, select

✔ Save Normal

.

Close the VBA Editor to return to Word.

Explanation:

Final answer:

To change an existing macro in Excel, navigate to the Developer tab and select Macros. Choose the macro you'd like to adjust and select Edit to open the VBA Editor, then alter the necessary code and save your changes.

Explanation:

To change an existing macro in Excel, several steps need to be followed:

  1. Go to the Developer tab on the ribbon.
  2. In the Macros group, click Macros.
  3. From the list of macros, select the one you want to modify and click Edit, which will open the VBA Editor.
  4. In the VBA Editor, locate the specific code that you want to change. Make the necessary changes, and then select _Save and Close.

Learn more about Modify Excel Macro here:

https://brainly.com/question/32200406

#SPJ4

Other Questions