Locked for editing problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan M - 25 Jan 2008 15:30 GMT

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?

Reply to this Message

Gary Keramidas - 25 Jan 2008 15:55 GMT

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.

Signature

Gary

>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
[quoted text clipped - 4 lines]
> Can anyone advise how I can recover this workbook and attached VBA code
> please?

Reply to this Message

Alan M - 25 Jan 2008 16:39 GMT

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

I tried rebooting and no luck

> 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.
[quoted text clipped - 7 lines]
> > Can anyone advise how I can recover this workbook and attached VBA code
> > please?

Reply to this Message

Gary Keramidas - 25 Jan 2008 19:17 GMT

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.

Signature

Gary

>I cannot save the file in another folder as I cannot open it to do so.
>
[quoted text clipped - 14 lines]
>> > Can anyone advise how I can recover this workbook and attached VBA code
>> > please?

Reply to this Message

Alan M - 25 Jan 2008 19:50 GMT

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

> do have code that runs when the file is open?
>
[quoted text clipped - 23 lines]
> >> > Can anyone advise how I can recover this workbook and attached VBA code
> >> > please?

Reply to this Message