Need advanced Excel, VBA or SQL support? Outsource your project now!
Connect to our Experts within seconds for a free diagnosis
Our professional experts are available now. Your privacy is guaranteed.

How to view macros in Excel – Excelchat

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.

Editing 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.

Leave a Comment


Subscribe to

Get updates on helpful Excel topics

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc