How do you force excel to save on close

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try to place a

Thisworkbook.Save

line in the BeforeClose event procedure!

Regards,
Stefi

„Tom Hewitt†ezt írta:
 
Thank you. Works like a charm.

Stefi said:
Try to place a

Thisworkbook.Save

line in the BeforeClose event procedure!

Regards,
Stefi

„Tom Hewitt†ezt írta:
Click to expand...
 
You are welcome! Thanks for the feedback!
Stefi


„Tom Hewitt†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save and close 2
"Save file before closing" 2
Save document on closure 1
Excel 2007 formula recalculation 1
Why does Excel ask to Save on Exit? 6
can't "undo" to original document 2
Excel How to Fix Damaged Excel File That Won't Open? 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top