I get exactly the same error in Excel, if there are VBA modules that
are password protected and one of them encounters an error the whole
of Excel explodes. If you can somehow go into the VBA and unlock the
module with the password then it works from there.

The other thing I have noticed is that when Excel blows up and you
restart, you need to check BEFORE in Task Manager that an instance of
EXCEL.EXE is not still running as otherwise it doesnt release the
variables causing the error and it keeps on happening.

Basically .... in a nutshell, clear down ALL of Excel and then restart
the program .....

HTH