elle said:
Every time I open or close excel it will show message as "Microsoft Visual
Basic : Compile error in hidden Module : AutoExec". I never install VB in my
computer.
Please let me know if anyone has any suggestions.
Thanks
Hi Elle,
This error is being caused by a malfunctioning Excel program that is
being loaded when Excel starts up. There are two places where program
workbooks could potentially be running from. Here's how to find them and get
rid of them:
1) Select Tools/Add-ins from the Excel menu.
2) In the Add-Ins dialog, uncheck every add-in that has a checkmark beside
it. Make note of the names of the add-ins you uncheck, then click OK.
3) Close Excel and use Windows Explorer to navigate to your XLStart
directory. If you installed Office to its default location, this will be:
C:\Program Files\Microsoft Office\Office\XLStart
If you're running Windows 2000 or XP, there's an additional start directory
you need to check located at:
C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART
Where <username> is the username you're logged in as.
4) If there are any files in the XLStart directory, move them to another
location temporarily (don't rename them and leave them there, it won't
work).
Once you've done all this, restart Excel and the problem should be gone.
To determine exactly which program file was causing the problem, add them
back one at a time, restarting Excel each time until you get the error
again. When that occurs, whichever one you added last is the culprit.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
