Macros can be stored in a single workbook file, available only to sheets in that workbook, or they can be stored in a global file so that they are available to all workbooks. We'll start by recording a basic macro and storing it in the Personal Macro Workbook.
Opening a File
We'll start by launching Excel.
Step1. Launch Excel.
Step2. To open an existing file,
Click Open Other Workbooks
NOTE for MacOS Users: To begin to open the file, in the left panel of the initial screen, Click Open, Click
NOTE for MacOS Users: Skip foward to the heading, "Setting the Location for Opening Your File".
Step3. To choose to open the file from this computer,
Click
Step4. To browse for the files,
Click
Setting the Location for Opening Your File
When the dialog box opens, it lists a default location from where the file will be opened. All of our exercise files are contained in the epclass folder, located on the desktop. We'll want to change our location to this folder.
We will start at the desktop, since our exercise file folder, epclass, is located there.
Step1. To move to the desktop,
Click
Step2. To open the epclass folder,
Double-Click
Step3. To open the correct folder,
Double-Click the Excel Macros folder
Step4. To open the first workshop file,
Double-Click macroex.xlsx