Oops! Can I recover the sheet?

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?
 
F

Frank Kabel

Hi Ian
unfortunately there is no way (unless you have a backup of your old
file)
 
T

Trevor Shuttleworth

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
 
D

Don Guillett

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
 
B

Bill Ridgeway

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
 
Top