Join Dennis Taylor for an in-depth discussion in this video Closing and updating the personal macro workbook, part of Excel for Mac 2016: Macros.
- [Teacher] In the previous movie,…I recorded a macro that highlights formula cells…in the current worksheet, and I stored it…in Personal Macro Workbook.…Now, if you were not doing that at the same time,…you don't have a copy of that macro.…So, in this file called UsefulMacros,…let's go to the Developer tab,…left button, Visual Basic,…and, then, under UsefulMacros, down the left-hand side,…let's open the Modules.…In Module2, this is a copy of the macro…that was recorded in the previous movie,…and I stored it in Personal Macro Workbook.…
Now, if you haven't done that,…what you need to do right now is to copy this,…with Command + C, go over to your Personal Macro Workbook,…and go to a module there.…If there is no module, you'll need to right-click…and insert a module.…But, if there is a module there,…and you don't necessarily needed to have named it Utility,…but if there's a module there,…you can certainly then paste it here with Command + V.…Now, something about Personal Macro Workbook…that we didn't stress in the earlier movie,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Working with existing macros
- Creating macros with the recording process
- Viewing and modifying VBA code
- Running a macro from the Developer or View tabs
- Running a macro from a keystroke shortcut
- Running a macro from an object or picture
- Creating and updating the Personal macro workbook
- Recording a formatting macro
- Expanding a macro with an IF statement
- Creating interactive macros
- Stepping through macros