jassociety.blogg.se

In either case, the easy way to create PERSONAL.XLSB is not to muck around with the file system directly.

On Windows XP, it lives here: C:\Documents and Settings\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB On Windows 7, it lives here: 3 C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB On my install of Windows 10, running Excel 2016, it lives here 1 2: C:\Users\wheatbread\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB Where it lives, though, is a moving target. If you use Microsoft Excel, and you have a macro that you want to be available globally–in any open workbook–you can place it in your Personal Macro Workbook, which is just an Excel Workbook (in binary, XLSB, format, for speed) that lives at a particular location, where Excel will look for it whenever it launches. Sometimes I blog things mostly so I can remember them and in the off chance that they might be useful to others.