How do you force excel to save on close

T

Tom Hewitt

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

Stefi

Try to place a

Thisworkbook.Save

line in the BeforeClose event procedure!

Regards,
Stefi

„Tom Hewitt†ezt írta:
 
T

Tom Hewitt

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