From the course: Excel: Macros in Depth

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Saving to the personal macro workbook

Saving to the personal macro workbook - Microsoft Excel Tutorial

From the course: Excel: Macros in Depth

Start my 1-month free trial Buy for my team

Saving to the personal macro workbook

“

- [Instructor] Not all solutions are for other people. Sometimes they are just for you. We do a lot of repetitive tasks with the files we use for our day-to-day jobs. This is where recording macros to the Personal Macro Workbook can be valuable. That way your macros will be available to you in any Excel workbook. For instance, the monthly data export. We receive this file each month from the database administrator. We always do the same three tasks. We increase the column width. We remove a few columns, and we bold the headings. We do this every time we receive this file before we ever dig into the real work. So let's record a macro and save it to the Personal Macro Workbook. Okay, I'll go ahead and hit my Record. Okay, let's call this the MonthlyDataRoutine. Okay, and we'll go ahead and give it a description of clean up report. Now, you want to store this macro, not in this workbook, but in the Personal Macro…

Contents