How do you force excel to save on close

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.
 
G

Guest

Try to place a

Thisworkbook.Save

line in the BeforeClose event procedure!

Regards,
Stefi

„Tom Hewitt†ezt írta:
 
G

Guest

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...
 

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
Excel How to Fix Damaged Excel File That Won't Open? 3
Do you wish to save prompt 1
Excel Unlink open excel files 2
Excel prompts to save when no changes made 2
Excel And Notepad 3
can't "undo" to original document 2
Save document on closure 1

Top