quit without saving option

  • Thread starter Thread starter john.9.williams
  • Start date Start date
J

john.9.williams

I have a program that sits on a network when the program closes it
always gives the user the option to save the file, can i stop this from
happening to that when the close button is selected on my userform the
file just shuts straight down

thanks
 
ActiveWorkbook.Close SaveChanges:=False

or, you can try setting the Saved property to True

ActiveWorkbook.Saved = True
 
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

closing another file by code causes failure to run workbook activate event 2
Hyperlink excel window problem 3
automation error when closing excel 3
Save workbook button on Userform 2
userform program keeps crashing 4
trying to get out 4
How can we convert OST to PDF file format? 1
userform and error excel has stopped working 5

Back
Top