If you normally keep your macros in a personal.xls workbook (in your XLSTART folder) but suddenly it doesn't open, try this technique for restoring it.
I assume you have already checked to make sure it isn't just hidden (Window>Unhide) or disabled (Help>About Microsoft Excel>Disabled Items).
1. Quit all instances of Microsoft Excel, then press Ctrl-Alt-Del and click the Processes tab (in Win XP).
2. Sort the running processes by filename by clicking on the first header.
3. Look for EXCEL.EXE and, if it is present, click 'End Process' and 'Yes' to allow the Task Manager to remove Excel from memory.
4. Repeat for any other instances of Excel still present in memory.
5. Open Excel normally and the personal.xls workbook should now open.
Works with:
Excel 2002
Excel 2003
on Win XP
–JP
About JP
Follow Me