Excel. I closed a spreadsheet without saving.?
Is there any way to recover the changes that were last made? The program closed before I had a chance to save it.
Is there any way to recover the changes that were last made? The program closed before I had a chance to save it.
Tony
Favorite Answer
no > it is gone
owsley
you'll want some VBA to try this. Open the spreadsheet. Press ALT+F11. interior the left-hand record, seem on your Spreadsheet. (that is going to in all probability be suggested as some thing like: "VBAProject (Spreadsheet.xls)". click on the "+" next to it. that is going to open up into: -Microsoft Excel gadgets --Sheet1 (Sheet1) *call of the sheet* --ThisWorkbook Double click "ThisWorkbook". that is going to open a white "internet site". on the precise would be 2 drop-down lists. One will say (widespread) and the different (Declarations). click on the arrow next to (widespread). choose for "Workbook". click on the different drop-down record, and choose "BeforeClose". that is going to upload right here to the white "internet site": inner maximum Sub Workbook_BeforeClose(Cancel As Boolean) end Sub Now, form this between the two strains: ThisWorkbook.saved = real you may have some thing looking like this: inner maximum Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.saved = real end Sub click on "record", and then on "close and return to Microsoft Excel". keep your Spreadsheet. once you open it next time, that is going to ask to "enable Macros". enable them. once you shut the Spreadsheet, it won't ask to keep. that is going to easily close, without saving something.