| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting "Personal.xls" file
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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Personal.xls" file
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 "Syed Zeeshan Haider" wrote in message ... 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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Personal.xls" file
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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" "Chip Pearson" wrote in message ... 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 "Syed Zeeshan Haider" wrote in message ... 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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Personal.xls" file
Syed,
Excel will function just fine without a personal.xls file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Syed Zeeshan Haider" wrote in message ... 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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" "Chip Pearson" wrote in message ... 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 "Syed Zeeshan Haider" wrote in message ... 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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Deleting "Personal.xls" file
Thanks for the quick response!
Special thanks for the help. Have a nice day! -- Syed Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" "Chip Pearson" wrote in message ... Syed, Excel will function just fine without a personal.xls file. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Syed Zeeshan Haider" wrote in message ... 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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" "Chip Pearson" wrote in message ... 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 "Syed Zeeshan Haider" wrote in message ... 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 Zeeshan Haider. http://szh.20m.com/ ----------------------------------- Allah says to Mankind: "Then which of the favours of your Lord will ye deny?" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Personal.xls error - "file Is already open" | Excel Discussion (Misc queries) | |||
![Syed Zeeshan Haider[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
