Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
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

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc