![]() ![]() You can see it as your Personal Macro code vault (or library). You just run them from the hidden Personal Macro Workbook.Īnother reason to use the Personal Macro workbook is that it’s a great place to store code samples (also known as code snippets) that you can copy and paste into your other macros. So you don’t need to put code in other workbooks to run the macros in your Personal Macro Workbook. You can run macros in the Personal Macro Workbook any time you have Excel open without needing to manually load the workbook yourself (because it’s opened by Excel on start up).Īny VBA code that you keep in this workbook will be accessible from any workbook that’s open in Excel. ![]() It’s a hidden workbook that opens automatically when you start Excel. Think of your Personal Macro Workbook as a personal code vault that stays in your computer. ![]() » Back to contents Think of it as a personal code vault #1 – Personal Macro Workbook – what is it and why does it matter? They’ll help you write Excel VBA Macros better and faster. Excel VBA Cheat Sheets » Find it hard to write Excel VBA Macros? Think there’s too much to remember? You’re not alone! Check out my convenient one-page guides. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |