| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save changes on close using vba
Hi All,
How can i programmatically save all changes made in a workbook, such that MS Excel doesn't prompt the user before they close the workbook? -- Carlee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
save changes on close using vba
hi
in a thisworkbook module, paste this. Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.Save End Sub everytime someone closes the file excel will save it whether it needs saving or not. regards FSt1 "Carlee" wrote: Hi All, How can i programmatically save all changes made in a workbook, such that MS Excel doesn't prompt the user before they close the workbook? -- Carlee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vba - Save but don't close | Excel Worksheet Functions | |||
| Save/Close All | Excel Discussion (Misc queries) | |||
| To save and close | Excel Worksheet Functions | |||
| Save and Close Pop Up Box...After Save and Close In VBA | Excel Programming | |||
| Close without save | Excel Programming | |||
Linear Mode
