Locked for editing problem

[Alan M]

I have a workbook with VBA programming in which caused Excel to close for
some reason. Now when I go to re-open the workbook and select either enable
macros or disable macros at the prompt. I receive an error message which says
the workbook is " locked for editing' and can only be opened as read-only. If
I then continue it causes Excel to crash and close down.

Can anyone advise how I can recover this workbook and attached VBA code
please?

 

[Gary Keramidas]

try saving it with the same name to a different folder. then open it and see if
it works. you may try to restart your pc to remove the lock, too.

 

[Alan M]

I cannot save the file in another folder as I cannot open it to do so.


I tried rebooting and no luck

 

[Gary Keramidas]

do have code that runs when the file is open?

try starting excel in safe mode and see if you can access the file.

if it's office 2003, try pasting this in the run box
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /s

or, hold down the shift key while you double click on the excel file.

 

[Alan M]

No the code is only simple formatting info on one worksheet

I have not been able to resolve the matter.

I am stumped on this one


I am using Excel 2000 so the Microsoft error reporting does not provide a
solution either