• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to View Macros in Excel

How to View Macros in Excel

By: Shreya Mehta
  • Share
  • Share on Facebook

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

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

Step

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

Video of the Day

Step

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.

Show Comments

Related Articles

How to Sort Alphabetically in OpenOffice

How to Sort Alphabetically in OpenOffice

Around The Home
Productivity
By: Ruri Ranbe
How Do I Import Macros for Excel?

How Do I Import Macros for Excel?

Around The Home
Productivity
By: Ron Price
Difference Between Xls & Xlsm

Difference Between Xls & Xlsm

Around The Home
Productivity
By: Mara Shannon
How to Lock Computer Screens

How to Lock Computer Screens

Around The Home
Productivity
By: Techwalla Contributor
How to Copy From One Worksheet & Paste to Another Using VBA

How to Copy From One Worksheet & Paste to Another Using VBA

Around The Home
Productivity
By: Stephanie Ellen
How to Find Hidden Macros in an Excel Spreadsheet

How to Find Hidden Macros in an Excel Spreadsheet

Around The Home
Productivity
By: Ken Burnside
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.