Rewrite the macro code

You can rewrite the converted code of the new macro directly in the Macro editor window, as described in the Edit macro section, or by viewing the VBA source code.

To rewrite the converted macro code yourself based on the source code in VBA, follow these steps:

1.Open the converted macro in the editor window as described in the Edit a macro section.

2.Click Show source code. The macro editor window will take on a new look, with the converted Lua code for the new macro on the left and the uneditable VBA source code from the related source macro on the right.

3.Make the necessary changes to the text of the new macro.

4.Save your changes in one of the following ways:

•Click Save as new macro. The new macro with the modified code will be saved under the original macro.

•Click Save. The changes will be added to the existing macro.

5.To exit edit mode without saving changes, click  Back, confirm the operation in the window that opens, and close the Macro editor window.