|
Size: 681
Comment: triple mustache displays raw text, avoiding linking the camelcase directory name(s)
|
Size: 933
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| == Creating a Personal Workbook == | = Personal Workbook = |
| Line 3: | Line 3: |
| To make an Excel macro globally available, add it to your Personal Workbook. Simply save an Excel file with a macro embedded to: {{{C:\Users\USERNAME\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB}}} | Excel VBA lives inside Excel workbooks. Macros can only be executed if its workbook is locally open. The '''personal workbook''' is always opened and available, and as such makes for an appropriate way to make macros or functions globally available. |
| Line 5: | Line 5: |
| == Personal Workbook Missing == | <<TableOfContents>> ---- == Setup == Simply save an Excel file with a macro embedded to: {{{C:\Users\USERNAME\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB}}} ---- == Troubleshooting == === Personal Workbook Missing === |
Personal Workbook
Excel VBA lives inside Excel workbooks. Macros can only be executed if its workbook is locally open. The personal workbook is always opened and available, and as such makes for an appropriate way to make macros or functions globally available.
Setup
Simply save an Excel file with a macro embedded to: C:\Users\USERNAME\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB
Troubleshooting
Personal Workbook Missing
Microsoft will periodically disable and delete your Personal Workbook. To re-enable:
In an Excel window, navigate to File > Options
In the popup, navigate to Add-ins
In a dropdown located near the bottom of the popup, select Disabled Items and Go
In the popup, select Personal Workbook and Enable
- Restart Excel