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.
Creating the Personal Macro Workbook
From the course: Excel: Macros in Depth (Microsoft 365)
Creating the Personal Macro Workbook
- [Instructor] With some Excel macros, either at the time you're recording them, or later for an existing macro, you've realized that the macro has wide applicability, not just for the current workbook where you recorded it. So when recording a macro, if you want to make it available to all workbooks, you store it in what's called personal macro workbook. Now that might not even exist. On the screen we've got one workbook open, useful macros. If we press alt+F+11, let's go to visual basic window, we might or might not be seeing personal macro workbook down the left-hand side. If it doesn't exist, we don't see it there. So right now on my screen there is no personal macro workbook. It has not been created, alt+F+11. How do we create the personal macro workbook? We do it simply by recording a macro and storing it there. Now, with existing macros, and as I press alt+F+11, in this workbook here we have some macros already,…
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.