How to View Macros in Excel

By Shreya Mehta

Macros are useful scripts of Visual Basic code that are used to automate manual tasks in Microsoft Excel. They can easily be recorded for basic tasks or for users who are not familiar with Visual Basic code. Advanced users can edit macros in a Visual Basic editor to add code such as loops. Learn how to view macros by following the simple steps below.

Step 1

Open the Excel file that contains the macro. Go to the "View" tab in the toolbar.

Step 2

Click on "Macros" and select "View Macros."

Step 3

Select the macro from the list and click on the "Edit" button. The Visual Basic editor will be launched and the code can be viewed.