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.
Instant Connection to an Expert through our Excelchat Service
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.