| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving when closing excel
Aaaaagghhh, please can someone help me??
Somethings happened to excel, when I close a workbook down by using the cross in the top right hand corner, it doesn't automatically ask me if I want to save. I have now lost quite a bit of work, I know I should have learnt my lesson and save using the file menu, force of habit means I keep relying on it asking me when I close though. Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving when closing excel
hiput this in the thisworkbook before close module.
Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.Save End Sub each time you close the file, excel will auto save. Regards FSt1 "welshmag" wrote: Aaaaagghhh, please can someone help me?? Somethings happened to excel, when I close a workbook down by using the cross in the top right hand corner, it doesn't automatically ask me if I want to save. I have now lost quite a bit of work, I know I should have learnt my lesson and save using the file menu, force of habit means I keep relying on it asking me when I close though. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to code on Macro on saving and closing a file? | Excel Worksheet Functions | |||
| How do I undo changes after saving and closing a document | Setting up and Configuration of Excel | |||
| closing & saving | Excel Worksheet Functions | |||
| Is there any way to recover changes after closing w/o saving? | Excel Discussion (Misc queries) | |||
| Closing Excel without saving | Excel Discussion (Misc queries) | |||
Linear Mode
