Question about Microsoft Office Excel 2003 for PC
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.
Posted on Oct 20, 2009
Testimonial: "Thank you, I see that I have much more to learn about working with macros:). Thanks, MaArtin."
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.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 10, 2013 | Microsoft Excel 2010
Jan 03, 2013 | Computers & Internet
Feb 12, 2012 | Apple Computers & Internet
Mar 29, 2011 | Microsoft Windows XP Professional
Oct 01, 2010 | Computers & Internet
Aug 30, 2010 | HP Office Equipment & Supplies
Oct 03, 2009 | Microsoft Office Professional 2007 Full...
Jun 24, 2008 | Dell Latitude D600 Notebook
Dec 18, 2007 | Microsoft Office Standard for PC
Jul 31, 2017 | Microsoft Office Excel 2003 for PC
Apr 13, 2017 | Microsoft Office Excel 2003 for PC
175 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: