G'day there Greg,

I have a project with a relatively large amount of code. I now often get the
message: "Excel has encountered a problem and needs to close. We are sorry
for the inconvenience." I have used Rob Bovey's Code Cleaner several times to
no avail. I have no OLE objects in the project. It doesn't happen
often/reliably enough to try process of elimination, selectively commenting
out code and testing if it still happens. So I cannot source the problem.

I once had this crop up quite frequently on one particular
project. Following advice from this group I set Excel to not run macros
on startup (I had a few autorun bits in there), loaded my workbook,
opened the editor and from the Debug menu clicked CompileVBAProject.
When that finished I then saved the file and reopened normally. Problem
solved. I later stuffed up the code again and had the same error appear,
but that procedure fixed it again. Dunno if yours is the same problem,
but the process is painless & can't hurt anything if you try it.

See ya
Ken McLennan
Qld, Australia