View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default How do you force excel to save on close

You are welcome! Thanks for the feedback!
Stefi


€˛Tom Hewitt€¯ ezt Ć*rta:

Thank you. Works like a charm.

"Stefi" wrote:

Try to place a

Thisworkbook.Save

line in the BeforeClose event procedure!

Regards,
Stefi

€˛Tom Hewitt€¯ ezt Ć*rta:

Having trouble with an excel user not saving an excel document even if she is
prompted to.

Is there anyway you can set an excel file up to save as its closed.