As we work with Excel workbooks, we might be required to view and edit macros. This is a simple and straightforward thing, but few people know how to do it. This post looks at how one can easily view macros in Excel.
Change macro security settings
For you to be able to view and edit macros in Excel, you first have to change the security settings. To do this, follow the procedure below;
Step 1: Click macro security under the Developer tab in the Code group
Figure 1: Macros security
Step 2: Enable all macros
The next thing you need to do is to click on Enable all macros under Macros settings.
In the above procedure, we have been able to enable macro settings. The next thing is now to edit macros.
But before we edit macros, we first need to view the macros. To do this, we simply need to click on the Developer tab and the under the Code group, click Macros. You will then be able to view macros.
After you have clicked on Macros, you will be presented with a Macros Name box. In the box, click on the macros that you want to edit.
Figure 2: Macro name box
When you click Edit, you will be presented with the Visual Basic Editor. From the editor, you will be able to edit your macros.