View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SthOzNewbie SthOzNewbie is offline
external usenet poster
 
Posts: 4
Default Auto-save on close

In Excel 2000 is it possible to imbed some code in a worksheet that will
automatically save the file when it is closed (rather than go through the
"are you sure...." routine). The standard autosave add-in is already being
used but the user wants to be able to close the sheet and not be prompted -
just have the file saved as default.

TIA

IK