One more quick question:

A strange problem: for some reason when I run one particular excel  VBA
application it runs, but when I want to view the code, the VBA editor
wouldn't open at all (the CPU usage goes to 100% and stays that way,
and after a while, the message 'not responding' appears). The same
Excel file cannot be saved as any other file either.

It was working fine when I saved it last (there were a couple of power
failures after that). My other excel-VBA applications  do open up for
editing.

Is there a way I can recover the macro code from this file? I searched
for answers, some suggested correcting the registry (but since the
remaining workbooks allow opening of VBA, I am not sure I should
attempt that).