Prompt to save

MDAUME · #1 (**permalink**) 06-24-04, 17:47

Can a file be configured so that it dosent ask if you want to save changes upon exit?

Matthew

DavidCoutts · #2 (**permalink**) 06-25-04, 06:03

you can put in the workbook_beforeclose Event you can add the code

ThisWorkbook.Saved = true
but if you want the workbook be saved make make sure you put the code into the event ot save the workbook

HTH
David

MDAUME · #3 (**permalink**) 06-25-04, 09:18

Quote:

Originally Posted by DavidCoutts

you can put in the workbook_beforeclose Event you can add the code

ThisWorkbook.Saved = true
but if you want the workbook be saved make make sure you put the code into the event ot save the workbook

HTH
David

Worked Perfect!

Thank you David.

Matthew

Internet Services

Web Development

Digital Marketing

Consumer Tech