app.quit
 

When I am ready to close my ws, I have a button that clears all contents
so the sheet is a blank form ready for the next usage. The last command
on my 'Clear' button is Application.Quit. It always asks if I want to
save my changes. Is there a way to disable this so that it will just
quit when I click my command button?
Thanks for the info
Joanne

app.quit
 

The last sentence of the help files for Quit says this...

"If you set the Saved property for a workbook to True without
saving the workbook to the disk, Microsoft Excel will quit
without asking you to save the workbook."

So, executing this...

ThisWorkbook.Saved = True

before your Application.Quit statement should do it for you.

Rick


"Joanne" wrote in message
...
When I am ready to close my ws, I have a button that clears all contents
so the sheet is a blank form ready for the next usage. The last command
on my 'Clear' button is Application.Quit. It always asks if I want to
save my changes. Is there a way to disable this so that it will just
quit when I click my command button?
Thanks for the info
Joanne

app.quit
 

Thanks
MVP - VB\ wrote:

The last sentence of the help files for Quit says this...

"If you set the Saved property for a workbook to True without
saving the workbook to the disk, Microsoft Excel will quit
without asking you to save the workbook."

So, executing this...

ThisWorkbook.Saved = True

before your Application.Quit statement should do it for you.

Rick


"Joanne" wrote in message
...
When I am ready to close my ws, I have a button that clears all contents
so the sheet is a blank form ready for the next usage. The last command
on my 'Clear' button is Application.Quit. It always asks if I want to
save my changes. Is there a way to disable this so that it will just
quit when I click my command button?
Thanks for the info
Joanne