From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Closing and updating the Personal Macro Workbook
From the course: Excel: Macros in Depth (Microsoft 365)
Closing and updating the Personal Macro Workbook
- Most Excel users are attuned to the idea that when they open workbooks and make changes, from time to time they save their changes. Now, what if you opened Excel a few hours ago, you've opened and closed different workbooks, and you're also using macros in personal macro workbook? When we press Alt F11, we're in the world of visual basic. If the personal macro workbook is available, and we created this in the previous movie, we see it here on the left-hand side, in the project window. Just as with any other file, if this has been open and you've been making changes, maybe adding modules or changing the code within modules, what happens if there were a system failure, or a system crash? I know it doesn't happen a lot, but when it does, what would have happened to the changes we made in personal? They would not have been saved. So periodically, if you're working with a personal macro workbook, in this VBA window, click on…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.