Deleting "Personal.xls" file

  • Thread starter Thread starter Syed Zeeshan Haider
  • Start date Start date
S

Syed Zeeshan Haider

Hello Experts,
I have Excel 97 Pro on Win98SE.

I have written some complex macros in "Personal.xls" and locked them with a
password. Now I have forgotten the password and unable to edit the macros.
Fortunately, I have the backup copies of the macros as *.bas files. I can
edit and insert them into Personal.xls. But I am unable to access its VBA
project files.
If I delete Personal.xls then will it be recreated by Excel as it is
launched (like word does if Normal.dot is deleted)?
Or is there any other easier way to restore the "default" Personal.xls?

Thank you,
 
Syed,

You can recreate the personal.xls file by recording a macro and
indicating that you want it stored in the personal.xls file.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks for response!

Does it mean that Personal.xls is only needed for global macros, otherwise,
Excel works fine without it?
Am I right?

Thanks!
 
Syed,

Excel will function just fine without a personal.xls file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Thanks for the quick response!

Special thanks for the help.

Have a nice day!
 
Back
Top