Compile error problem

[julhs]

I was editing a module and had a power cut.
Now when I reopen the workbook I get message box saying;

Compile error
Invalid outside procedure
With “OK and Help” options

But regardless of selecting “OK” I can’t get back into the sub to complete the editing.
At the moment my only coarse is to use “Task Manager” to “End Task” and exit Excel,
but that leaves the workbook with the “Compile error” that can’t be resolved.
I’ve tried an Excel repair, just in case and tried opening offending workbook in “Safe mode”, without effect.

Anybody have any suggestions?

 

[MARK858]

Have you tried opening a second workbook and try and get the VB Editor up, then see if you can get into the offending module?

 

[julhs]

I'll give it a go

 

[julhs]

Thanks Mark
Your suggestion DID allow me to get back to the offending Workbook/Module and complete the editing; so was able to subsequently eliminate the compile error.

 

[MARK858]

You're welcome, happy it helped

 

[julhs]

Youv'e saved my sinity