View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default autosave before close

hi,
In the workbooks before close event put
private sub
ActiveWorkbook.Save
end sub

-----Original Message-----
Hi,
Can someone please remind me the VBA code for autosaving

the active workbook
with the same name without beeing prompt by windows ("do

you want to save
the changes you made to "aaa.xls") ?
TIA
J_J


.