Enabling Macros

Learn how to enable macros within the House Flipping Spreadsheet.
Creating a Template Spreadsheet
Next Video

Enabling Macros

2:32
Learn how to enable macros within the House Flipping Spreadsheet.

Video Topics

  • 01:05 - Option 1 - Yellow Message Bar on Workbook Open
  • 01:30 - Option 2 - Manually Changing Your Macro Settings

Video Transcript

What are macros and why do they need to be enabled?

Macros are little programs that run within Excel that help automate common tasks, navigation, data crunching and reporting that operate behind the scenes of the spreadsheet.

Macros are used throughout the House Flipping Spreadsheet and in order for them to operate, they need to be enabled.

How do you enable macros?

There are a couple of different options for enabling macros in Excel:

Option 1 - Yellow Message Bar on Workbook Open

The first option is to enable macros when the message bar appears when you first open the spreadsheet.  

Typically, when you open a Macro-Enabled Workbook, a yellow message bar will appear at the top of the spreadsheet.  

On the message bar click, Enable Content which will enable the macros within the House Flipping Spreadsheet.

Downloading the House Flipping Spreadsheet

Start to Finish Overview

Opening the Spreadsheet

Creating a New Project in Google Sheets

Enabling Macros

Authorizing the Spreadsheet

Creating a Template Spreadsheet

Project Setup for Google Sheets

Setting Up the Project Setup Sheet

Zooming In Google Sheets

Creating a New Project

Sharing the Spreadsheet

Saving the Spreadsheet

Printing the Spreadsheet in Google Sheets

Printing to a PDF