• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel 2016: How to Install and Use Macros

Excel 2016: How to Install and Use Macros

March 18, 2018 by Mitch Bartlett 1 Comment

Want to learn how to use macros in Microsoft Excel 2016 to speed up repetitive tasks? This tutorial will help you get off and running with Excel macros.

Enable Developer Tab

You’ll need the Developer tab to record macros.

  1. Open Excel and select “File” > “Options” > “Customize the Ribbon“.
  2. Under “Main Tabs“, check the “Developer” box.
  3. Select “OK“.

Recording a Macro

  1. Select the “Developer” tab.
  2. Select “Record Macro“.
  3. Provide a name for your macro. Give it a shortcut key if you wish. This will enable you to hold the CTRL key and press another key to launch the macro.
  4. Choose where to store the macro.
  5. Provide a description if desired.
  6. Select “OK” when you’re ready to start recording.
  7. Perform the keystrokes and mouse clicks that you would like your macro to perform. Your steps will now be recorded.
  8. When you’re ready to stop recording, click off of the last cell, then select “Stop Recording“.

Installing Macro

If you have obtained a macro from another user or the Interent, you can use them with your worksheet using these steps:

From Separate Excel File

If you have receive a spreadsheet or workbook file that contains the macros you wish to use, simply open the file in Excel. it will then be available to use from “Developer” > “Macros“. Simply select the workbook in the “Macros in” section of the screen, choose the macro, then select “Run“.

From Form, Basic, or Class File

Some macros are available in Form (.frm), Basic (.bas), or Class (.cls) format. You can import these with these steps:

  1. Select the “Developer” tab.
  2. Choose “Visual Basic“.
  3. Select “File” > “Import“.
  4. Navigate to the file you wish to import, then select “Open“.

Using a Macro

If you have set your macro to use a shortcut, simply hold CTRL and press the key you specified as the shortcut key. Otherwise, you can perform these steps:

  1. Select the “Developer” tab and choose “Macros“.
  2. Select the macro you wish to use, then select “Run“.

 

You Might Also Like

  • Turn Macros On/Off in Outlook 2019/365
    Turn Macros On/Off in Outlook 2019/365
  • How to Connect Outlook 2016 to Gmail
    How to Connect Outlook 2016 to Gmail
  • How to Sync iPhone or iPad With Outlook 2016
    How to Sync iPhone or iPad With Outlook 2016
  • Fix "Error 1321" When Installing Office 2016 or 2013
    Fix "Error 1321" When Installing Office 2016 or 2013
  • Turn Mail Notification Sound On/Off in Outlook 2016
    Turn Mail Notification Sound On/Off in Outlook 2016
  • Outlook 2016: Backup/Export & Import Data
    Outlook 2016: Backup/Export & Import Data

Filed Under: Office

Reader Interactions

Comments

  1. Robyn Webber says

    February 6, 2020 at 1:33 pm

    This did not help. I have never set up a macros before. I am trying to set up a form that has increasing numbers for each form eg. 1002, 1002, 1003, for each time we create a new packing slip, or invoice etc. I don’t know how to type out what this is. can you please help?

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Windows 11: What is Dynamic Lock and How to Set It Up
  • How to Use Google Pay on Android
  • What is a Firefox Primary Password and How to Create One
  • Fix: Windows 11 Mic Not Working
  • How to Update Galaxy Tab S8
  • How to View a List of Recently Uninstalled Apps on Android
  • How to Sign Into WhatsApp on Multiple Devices
  • Dedicated Server vs. Shared Hosting Server

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy