![]() ![]() I have a macro that works but is clunky and not as fast as i’d like it to be. Video 1: How to create the Personal Macro Workbook, and why you should use it. I even explain how to record your first macro, and I have additional free training videos if you are new to macros and VBA. ![]() I have put together a video series that explains everything you need to know to get started with your own Personal Macro Workbook. Video Series on the Personal Macro Workbook But you can store any macro, function, or userform in your personal macro workbook. These are usually simple tasks like refreshing all the pivot tables or creating a list of all the sheets in the workbook. □ The Personal Macro Workbook is always at your side, ready to assist you with common daily tasks. Ladies, you can think of it as your Excel purse. I like to think of it as your Excel tool belt. This makes it easy to run your macros at any time. The nice part is that it opens in the background every time you open Excel. The Personal Macro Workbook is just an Excel workbook that stores all your macros in one place. This is one feature that makes Excel awesome! You probably already know that macros can help automate routine Excel tasks to save you time. The time change has inspired me to help you save an hour out of every work week. The Personal Macro Workbook can Save You Hours! □ If you get up before the sunrise then you might want to check it out. I still yawn in the morning, but it is a lot less grumpy. On a side note, my wife and I use a wake-up light (amazon link) instead of an alarm clock, and wake up in a much better mood these days. I don't know about you, but the “Fall back” time change always makes me a little sleepier for a few days. Technically the clock shifts in the middle of the night while you are sleeping, but I think that you really lose that hour over the course of an entire week with every yawn and eye rub you do. I live in the northern hemisphere (U.S.), and we lost an hour this past weekend. If you live in a country that observes Daylight Savings Time (over 70% of countries do), then this is the time of the year that the clock shifts an hour. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |