• Skip to main content
  • Skip to primary sidebar

Technipages

Smart phone, gadget and computer tutorials

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel 2016: How to Install and Use Macros

Excel 2016: How to Install and Use Macros

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

  • Enable Slashes (/) in Excel 2016
    Enable Slashes (/) in Excel 2016
  • Excel 2016: How to Lock or Unlock Cells
    Excel 2016: How to Lock or Unlock Cells
  • Excel 2016: Unhide Rows or Columns
    Excel 2016: Unhide Rows or Columns
  • Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365
    Copy and Paste Values Without Formulas in Excel…
  • Excel 2019 & 2016: Force "Open as Read Only" Prompt
    Excel 2019 & 2016: Force "Open as Read Only" Prompt
  • Turn Macros On/Off in Outlook 2019/365
    Turn Macros On/Off in Outlook 2019/365
  • Setting Up Macros in Google Sheets
    Setting Up Macros in Google Sheets
  • Office 2016: Where is InfoPath?
    Office 2016: Where is InfoPath?
  • Word 2016: How to Set Background
    Word 2016: How to Set Background

Filed Under: Office Tagged With: Excel 2016

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! Cancel reply

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

  • How to Increase the Size of Text on Any Website on iPad
  • Chrome: How to Fix Can’t Scroll Using Scrollbars
  • Samsung Galaxy S 21 Plus: How to Check How Much Memory Is Left
  • Google Photos: How to Export Your Albums
  • Bitwarden: How to Deauthorize All Sessions
  • Bitwarden: How to Clone an Entry
  • Bitwarden: How to View Your API Key
  • How to Fix Microsoft Teams Error 0xcaa80000

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.

Follow me on Twitter, or visit my personal blog.

You May Also Like

© Copyright 2021 Technipages · All Rights Reserved · Privacy