| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vb code for saving a workbook when shutting an excel file down
Hello,
I can't remember the code for a sheet to auto save when shutting it down.... It went something like sub Auto_saveme() Any suggestions? -- kelly m johnson Great Britain |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vb code for saving a workbook when shutting an excel file down
hi,
put this in a thisworkbook module Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.Save End Sub regards FSt1 "Kelly 1st" wrote: Hello, I can't remember the code for a sheet to auto save when shutting it down.... It went something like sub Auto_saveme() Any suggestions? -- kelly m johnson Great Britain |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vb code for saving a workbook when shutting an excel file down
Hello,
Thank you... When i put this in it asks me whether or not i want to save... is there any code that i can put in that'll do it automatically without it asking? -- kelly m johnson Great Britain |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a CSV file from Excel with 0 in front of Zip code | Excel Discussion (Misc queries) | |||
| Saving workbook in code | Excel Programming | |||
| Excel 2003: Alignment problems saving workbook as prn file. | Excel Programming | |||
| Saving a Workbook without code | Excel Programming | |||
Hybrid Mode
