Oops! Can I recover the sheet?

  • Thread starter Thread starter Ian Coates
  • Start date Start date
I

Ian Coates

I think I already know the answer to this, but I'm hoping I'm wrong.

I opened a file, modified the data on one sheet and deleted the other. I
then mistakenly saved the file over the existing (master) copy. Is there any
way to recover the deleted sheet?
 
Ian

not unless you have a backup tucked away somewhere. As far as I am aware,
deleting a worksheet is irreversible, as is saving over an existing
workbook.

Regards

Trevor
 
Ditto the others but this might help for the future. However, as written, it
will also overwrite the old one.

Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub
 
Possibly not unless you have Norton System Works or similar which may allow
you to bring back to life a file which may be in the Norton Protected
Recycle bin.

Would suggest you write protect master files. Then if you do make the
mistake of trying to overwrite you will be faced with a "Do you really want
to do that" question. This forces you to save with a new name.

<File><Save as><Options><Read only recommended>

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top