No items found.

Make a Macro Available Across ALL Workbooks

training industry - top 20 companytraining industry - top 20 companyWatch list company 2023
course library users
Make a Macro Available Across ALL Workbooks
This course is in the base subscription pack
Category
Personal Development
Course Duration
0:04
Subject Matter Expert
Deb Ashby
Provider
Assemble You
Countries
Australia, Ireland, New Zealand, United Kingdom, United States
ESG Course
Blog
No items found.
Suite
Endorser

Learn how to make your Excel macros available in any workbook you open. This quick tutorial guides you through the process of recording a macro and storing it in your Personal Macro Workbook, the key to making it accessible across all your files. We'll cover enabling the Developer tab, recording a simple macro, and understanding the crucial step of choosing the right storage location. Stop copying macros from one workbook to another and start saving time with this essential Excel skill.

Target Audience

Ideal for those looking to streamline workflows and make more effective use of Microsoft 365 applications.

Learning Outcomes

Record a basic macro in Excel.

Understand the function of the Personal Macro Workbook.

Save a macro so it can be used in any workbook.

Contextualised Content