To be clear, I only copy and paste other peoples sites sometimes in case the page I’ve linked to fails, which has happened a few times when people don’t carrying on hosting their sites.<\/p>\n
<\/p>\n
http:\/\/wheatblog.com\/2011\/08\/where-is-the-excel-personal-macro-workbook-located\/<\/a><\/p>\n Sometimes I blog things mostly so I can remember them and in the off chance that they might be useful to others. This post falls into that category. If you use Microsoft Excel, and you have a macro that you want to be available globally\u2013in any open workbook\u2013you 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.<\/p>\n On Windows 7, it lives here: 1<\/sup><\/a><\/p>\n On Windows XP, it lives here:<\/p>\n In either case, the easy way to create PERSONAL.XLSB is not to muck around with the file system directly. Instead, just record a macro in Excel and, when you\u2019re prompted to save it, choose Personal Macro Workbook<\/em> from the Store Macro In<\/em> drop-down menu on the Record Macro<\/em> dialog box. Record yourself typing a few numbers and adding some formatting to them or something similar. Afterwards, you can open up the Personal Macro Workbook via the Visual Basic<\/em> button on the Developer<\/em> tab later and delete whatever you record. Once you create it, your Personal Macro Workbook will be listed in the VBA Editor as \u201cVBAProject (PERSONAL.XLSB)\u201d.<\/p>\n 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. Even though you can\u2019t write any files to it, Excel 2007 and Excel 2010 also have XLSTART folders inside the Program Files directory. Here are the paths:<\/p>\n For Excel 2010:<\/p>\n For Excel 2007:<\/p>\n \u201cOffice 14\u201d is the internal name for Office 2010. It\u2019s actually the 13th version of Office, but Microsoft saw fit to skip naming it Office 13, due, one suspects to superstition. So \u201cOffice 12\u201d is Office 2007, \u201cOffice 11\u201d is Office 2003, and so on. If you happen to be stuck running Excel 2003 on a Windows XP box, you\u2019ll find PERSONAL.XLSB at this path:<\/p>\n .<\/p>\n","protected":false},"excerpt":{"rendered":" To be clear, I only copy and paste other peoples sites sometimes in case the page I’ve linked to fails, which has happened a few times when people don’t carrying on hosting their sites. http:\/\/wheatblog.com\/2011\/08\/where-is-the-excel-personal-macro-workbook-located\/ Sometimes I blog things … Continue reading \n
C:\\Users\\AppData\\Roaming\\Microsoft\\Excel\\XLSTART\\PERSONAL.XLSB<\/pre>\n<\/blockquote>\n
\n
C:\\Documents and Settings\\Application Data\\Microsoft\\Excel\\XLSTART\\PERSONAL.XLSB<\/pre>\n<\/blockquote>\n
Some Additional Details for the Truly Nerdy<\/h3>\n
\n
C:\\Program Files\\Microsoft Office\\Office14\\XLSTART\\<\/pre>\n<\/blockquote>\n
\n
C:\\Program Files\\Microsoft Office\\Office12\\XLSTART\\<\/pre>\n<\/blockquote>\n
\n
C:\\Program Files\\Microsoft Office\\Office11\\XLSTART\\<\/pre>\n<\/blockquote>\n<\/blockquote>\n