Most likely this workbook will be found in the directory below:Ĭ:\Users\ UserName\AppData\Roaming\Microsoft\Excel\XLSTART
Should you need to copy your personal macro workbook from one PC to another (maybe from your work desktop to your home laptop,) you could do this by locating the XLSTART folder containing your personal workbook and copying your workbook file between both computers.
Alternatively, you can always easily edit VBA code of your personal workbook macros using the Visual Basic Editor (VBE) environment. Navigate to the View tab, click on Unhide dialog box, and then select your PERSONAL.XLSB file and click OK to view it. To edit existing macro in your personal workbook, you would need to first unhide your personal workbook. Should you want to use a shortcut to save you a step, ALT + F8 would do the trick. To run your macro, you can either navigate to the View tab, or Developer tab and then click on Macros, all of the macros in the personal macro workbook would show under the Personal! location. To create another macro and save it in your personal macro workbook, follow the same steps and re-save your workbook. They type of action you actually record is not overly important, as you can easily edit your VBA code once your stop recording your macro and save changes to your personal workbook. The key is to ensure that you store your macro in Personal Macro Workbook location. To record a macro, we simply need to navigate to the Excel ribbon and select the View tab, click on Macros and then Record Macro alternatively, you have your Developer tab enabled, you could invoke a Record Macro wizard from there. The easiest way to save your code into PERSONAL.XLSB workbook is through recording a macro. This productivity hack would help us perform repetitive tasks (formatting and data presentation pet peeves, anyone) by automating them. This is where the personal macro workbook comes into play: if we save our code in this centralized place, we could use it in any Excel workbook on our local drive. While the power of Excel VBA is limited only by our creative imagination, the real limitation of a typical VBA code comes from the fact that it resides in the workbook where it was saved, and as such, can only be revoked while this file is open. I also work as an engineer since i finished college a few months ago and my salary income cannot be seen on the dashboard, there is a separate sheet where i manage cashflow.We have already explored different Excel VBA macros here, here, and here. This is the database the spending macro insert information into ( ) Insert Grinds - i give private math tuition and i keep track of this by inserting the income here. Insert Spend - opens a template where i can insert an amount i have spent on a specific item from a specific category ( ) The buttons on the right perform specific functions.Īdjust screen - adjusted the screen to fit the dashboard to whatever computer you happen to be viewing on.īackup Data - creates a backup copy of the file and stores it in a separate location on my personal computer (would like to have this store externally also). Thought i should ad some extra description. Just wanted to share, think its something everybody should do. Its very informational for me and helps me plan/budget quite effectively. I track every penny I spend and have automated the process using simple VBA code and macros. My personal finance dashboard I made in excel.