Personal workbook does not save when it changes

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

I am using XL 2002. I created a Personal workbook, put it in the XL
startup folder, and hid it. But when I add a macro to it, I am not
prompted to save it when I shut down XL. Why?

Thanks,

Billy
 
When you start Excel and click on Windows - Unhide, does the Personal.xls
file appear? Or is Unhide grayed out? I don't know how you created that
file but you should let Excel create it and place it. To create the file,
click on Tools - Macro - Record New Macro. When it asks where to place the
macro, specify Personal.xls. I know it doesn't exist. Click OK. That's
it. The Personal.xls file is created and placed. Otto
 
Back
Top