Hi everybody,

I'm finishing my VBA-Project (Excel 97), and right now this error keeps showing up:


My workbook creates a commandBar when I open it. One button on it will show a form, which gathers information from other workbooks (open, read, close) and then gives a nice review of it. All my code is in one module (or in the form).

This morning, though, I was editing a loop (in debug mode) which checks through the open workbooks to see if one needs to be closed. It's OK for Excel to ask me to restart the macro, but normally it says "Your program needs to be restarted after this edit. OK/Cancel" (I don't run an english OS here). Only that this time Excel marked the "End Sub"-line of the very sub I was editing and told me "Restart is necessary." No confirmation, just this.

Now, it got weird. The commandBarButton would no longer find the subs he should call, though they are in the same module. And when calling any of my subs, even the most simple, from the direct window, I get a "Not possible to execute requested function" error. Excel sometimes crashes from this.

Note: When I copy&paste everything from my module to a new module, it will work until I have to fix something and the "Restart is necessary"-error comes up again.

What can I do??

Please help me!