1 Suggested Answer

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.Goodluck!

Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.

You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART
On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls
1. Open Excel,
2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor)
3. Click Tools-References to bring up the references dialog
4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located.
5. Click Cancel to close the dialog.

If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Have you ever forgotten your Excel workbook or sheet password? Here you can download a FREE Excel add-in that removes/cracks sheet and workbook password protection in Excel®.
NB! This program can't remove file protection, i.e. if you are unable to open the file, this program won't help you. You could try Excel Key to remove file protection. If you need to crack the VBA-password try this one.
This Excel add-in (password.xla) works fine in Excel 5.0 and above (including Excel 2000, XP and 2003).This program will remove passwords of any length, also passwords containing special characters.
Download here: password

Excel Password Recovery is software that will recover lost or forgotten passwords for MS Excel spreadsheets (*.xls). Our Excel Password Recovery software will recover MS Excel 97/2000/XP/2003 passwords at approximate 2,000,000 Passwords/Minute!
tips:there is another software called office password recovery 5.0 can not only unlock excel password but also unlock word password,you may also have a try.