Join Dennis Taylor for an in-depth discussion in this video Closing and updating the personal macro workbook, part of Excel 2010: Macros in Depth.
- View Offline
- Exercise Files
Once you have created a personal macro workbook and have started to use it on a…regular basis, you want to be sure that when you make changes to macros there…that they're currently up to date.…And you might notice this, too: when you enter Excel after having created the…personal macro workbook, the Unhide button on the View tab is selectable.…Now even if this file is closed--it's an empty file, I'll just close it--that…Unhide button is still there.…It's a reminder that we have a hidden workbook that's open; we're not seeing it.…
It's the personal macro workbook.…It's always available whenever you open Excel once it has been created.…And whether we have a file open here or not, we can quickly press Alt+F11 and…see that the personal macro workbook is there and see the macros that are in…it. Here is Module1.…You do have control over the organization of macros here. And what if you make…changes to the macros? If we were not altering files, necessarily--…now probably we are most of the time, but let's imagine jumping back into Excel here.…
- Understanding what a macro does
- Recording and adding functionality to a macro
- Running macros
- Creating non-recordable VBA code
- Testing a macro in Step mode
- Joining two macros
- Using loop structures
- Streamlining macros
- Creating a Personal Macro Workbook
Skill Level Intermediate
1. Getting Started
2. Running a Macro (Execute, Play Back, Etc.)
3. Using Visual Basic for Applications (VBA)
Viewing the VBA components6m 50s
4. Recording a Macro in Stages
Recording a simple macro5m 52s
5. Creating Non-Recordable VBA Code
6. Macro Project: Converting a Mailing List into a Database List
7. The Personal Macro Workbook
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.