View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Tom Hewitt Tom Hewitt is offline
external usenet poster
 
Posts: 12
Default How do you force excel to save on close

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.