The location of the Personal Macro Workbook is a little confusing, because older versions of Excel stored it in an XLSTART folder buried inside the Program Files folder.
Some Additional Details for the Truly Nerdy The path to the XLSTART folder will appear, even if it is hidden in Windows. If the immediate window is not visible, press ctrl+command+g to make it so.In the immediate window, type ?Application.StartupPath.If the immediate window is not visible, press ctrl+g to make it so.The only difference is the shortcut keys you use to interact with it.
#WHERE ARE FILE OPTIONS IN EXCEL FOR MAC MAC#
These days, both the Mac and Windows versions of Excel support VBA and have basically the same VBE. The best way to find the path–hat tip to commenter Kevin Woodward–is to use the Visual Basic Editor (VBE). Once you create it, your Personal Macro Workbook will be listed in the VBA Editor as “VBAProject (PERSONAL.XLSB)”. Afterwards, you can open up the Personal Macro Workbook via the Visual Basic button on the Developer tab later and delete whatever you record. Record yourself typing a few numbers and adding some formatting to them or something similar. Instead, just record a macro in Excel and, when you’re prompted to save it, choose Personal Macro Workbook from the Store Macro In drop-down menu on the Record Macro dialog box. 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
#WHERE ARE FILE OPTIONS IN EXCEL FOR MAC INSTALL#
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.
0 kommentar(er)
