Excel Error

[LesHurley]

When I first call any of my VBA functions from any worksheet in EXCEL I get
an error dialog that says, " Microsoft Office Excel has encountered a problem
and needs to close. We are sorry for the inconvenience". It then gives me
my choice of sending an error report or not sending. If I open the VBE with
Alt/F11 and then immediately close it, the problem goes away until the next
time I start EXCEL. Does anyone know if this is a bug, or what? This
problem didn't always occur and I haven't changed any of my VBA functions
sice long before it started. I'm using EXCEL 2003.

 

[Kevin B]

Go to the following folder, substituting the name of the folder your
documents are under for UserName in the following path:

C:\Documents and Settings\UserName\Application Data\Microsoft\Excel

If there's a file named Excel11.xlb in the Excel folder at the end of that
path delete it and seeif that doesn't fix the problem.

 

[Kevin B]

I should of included this in my prior post. Another Ready/Fire/Aim moment.

For a complete explanation regarding the XLB file go to Chip Pearson's web
site at the following URL:

http://www.cpearson.com/excel/StartupErrors.aspx

 

[LesHurley]

Nope; Still does the same thing. I will take a look at the link you gave me
in your PS.

 

[LesHurley]

OK Kevin; I reRegistered EXCEL according to Pearsons instructions. The
problem persists. Actually, I don't appear to have an EXCEL startup problem.
Everything works normally except for VBA. It seems very strange to me that
all I have to do tomake it work is open the VBE and immediately close it.
Wierd!

 

[LesHurley]

I posted the message below a couple of months ago and I took Kevin's advice
but still couldnt fix the problem. In the mean time I have been working with
a microsoft technical support person on another problem, which he fixed but
can't help me with this one. Does anyone have any new ideas.

 

[LesHurley]

Kevin, I just now noticed that deleting Excel11-xlb deletes my custom
toolbar. restoring the toolbar also restores that file. The problem remains
in either case.