Compile Error in Hidden Module: Projects

[Guest]

It seems everytime I open a new Excel workbook or an existing one I recieve a
Visual Basic Editor error that says: Compile Error in Hidden Module:
Projects.

When I close any Excel spreadsheet the error reappears and I can hit OK and
continue working with out any problem. I have Office 2003 running with XP
Pro. SP2 is no installed.

 

[Chip Pearson]

You probably have a misbehaving addin. See
www.cpearson.com/excel/startuperrors.htm for some steps to remedy
the problem.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Thanks Chris the step to remove the contents of the XL Start was what fixed
this problem.

 

[Guest]

Chip, you're a genius. I was having a similar problem whenever I would try
to launch the open file dialog. I followed your tshooting steps; something
in the xlstart folder was causing the problem. Thanks!

 

[Guest]

Chip -
Wanted you to know you helped another person too. I had to try several
things before coming up with the one I needed which was in the XLStart
folder. You've helped me with a MAJOR irritation.
Thanks so much.
Ann Shaw

 

[Guest]

One more thank you. This helped solve the problem that was driving me crazy.
Although my search claimed my XLSTART folder was empty, I was able to go to
the Visual Basic screen and find it by following these directions I got from
Dave Peterson's post at Egghead:

Go into the VBE.
You should still be able to see VBAProject(jwpacke.xls) in the project
explorer.
Hit ctrl-g to see the immediate window.
Type the following and hit enter
?workbooks("jwpacke.xls").fullName
Note location of file.


Thanks again for helping to preserve sanity.

Jeannie

 

[Wallinthegarden]

An immensely useful tool but sadly it didn't remove the problem even after
going through all the options. Any more recent thoughts? Mind you, once
Excel is loaded, I can just ignore the error message it all seems to work
fine thereafter! I seem to have no Addins anyway, COM or otherwise!

 

[Kertbank]

Like you I went through all the steps layed out in Cpearson.com link
(www.cpearson.com/excel/StartupErrors.aspx) but to no avail. For one thing I
could not find the xlb file referred to. I wonder if the problem is that the
Cpearson fix was written for Excel 2003 and we are having a problem in Excel
2007.

 

[Robert Flanagan]

Click Office Button, Excel Options, Add-ins, Manage Add-ins, Go

Uncheck all add-ins. Close and restart Excel. If the problem goes away,
then it is one of the add-ins causing the error message. Contact the
publisher for a fix.

If not, Search your hard drive for personal.xls. Go to its folder, and
remove it and any files in it. There may be several. This prevents them
from starting up. If the problem goes away, add back the files one at a
time until the problem re-occurs. Contact the person who supplied the file
and ask for a fix.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel