Question

Describe the steps to change an existing macro in Microsoft office 2016

Answer 1

Answer:

How to edit a macro / change the macro

1. Display the Visual Basic Editor.

2. From the Tools menu, choose Macros.

3. In the Macros dialog box, from the Macros In the drop-down list, select the project containing the macro you want to edit.

4. In the Macro Name list box, select the desired macro.

5. Choose Edit.

6. In the Code window, make the desired edits.

7. Close the Macros dialog box.