MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cannot save macro in Personal Macro Workbook in the XLStart folder

Posted by A.R. on April 10, 2001 9:26 AM

I cannot save a macro in the "Personal Macro Workbook" because I don't have access to the H drive where the XLStart folder is located. When I record a macro in the "Personal Macro Workbook" and close Excel, I get an error message telling me Excel can't access the file "H\APPs32\...\XlStart". Is there a way to have Excel store macros in the Personal Macro Workbook" in the C drive? I have no problem when saving a macro in "This Workbook" but I need macros available for several different Excel files.

Posted by Bob on April 10, 2001 10:54 AM

Try creating a folder called 'XLSTART' in the 'C:\Program Files\Microsoft Office\Office' Folder on your C: Then put a sheet in that Folder.

Posted by lenze on April 11, 2001 6:31 AM

Create a folder on your C:drive called Altxlstart (you can put it in a sub directory if you want). Now, start Excel and choose Tools-Options. On the General Tab, enter the path to this folder in the Alternate Startup Folder field. Then store your personal.xls here in this altxlstart folder. don't forget to hide your personal.xls workbook before saving.

Posted by A.R. on April 11, 2001 12:35 PM

Thank you Lenze

Lenze: Your method worked. Thank you.