Alternatively, choose Code > Visual Basic for PC and Visual Basic > Editor for Mac. Step 2: Open The Visual Basic Editor (VBE) Note: To avoid redundancy, unless I state otherwise, we will be using the Developer tab, so I won’t include Developer in every set of instructions. To enable it on a PC, go to File > Options, then choose Customize Ribbon > Select Developer under Customize the Ribbon, and press OK.įor Mac, go to Excel > Preferences, then choose Ribbon > Customize, Select Developer, and press OK. To work with macros, you’ll need to enable the Developer tab, which is hidden from the Ribbon by default. If you want to follow along, you can download the Excel file I’ll be using in the demo. So I’m going to show you how to take a macro you find online or get from a trusted source and add it to your workbook and run it - on both a PC and Mac. And I’m writing this post because I’m assuming that I’m not the only one who has done that.
Have you ever done a search to find out how to do something in Excel, just to find the search results littered with macro options? I used to avoid those results like the plague because I found macros (at least those beyond what I could create with the Macros Recorder) really intimidating.
