|
⇤ ← Revision 1 as of 2020-01-02 17:13:01
Size: 675
Comment: Initial commit
|
Size: 681
Comment: triple mustache displays raw text, avoiding linking the camelcase directory name(s)
|
| Deletions are marked like this. | Additions are marked like this. |
| 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 | 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}}} |
Creating a Personal Workbook
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
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