View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Macro to Save File to specific location when closing

Forgot that one<g


Gord

On Mon, 26 Oct 2009 17:13:45 -0500, Dave Peterson
wrote:

But what happens if the user wants to close the workbook without saving and then
your macro saves the file automatically.