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.