Macro code to exit Excel without prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

can someone please provide the VB macro code that will exit excel without prompt, also with prompts please. (Prompting meaning "Do you want to Save book1.xls" etc.

Thanks

Adam
 
ActiveWorkbook.Saved=true




Adam said:
Dear all,

can someone please provide the VB macro code that will exit excel without
Click to expand...
prompt, also with prompts please. (Prompting meaning "Do you want to Save
book1.xls" etc.
 
Because the Saved property is being set to True, Excel acts as if the
workbook has already been saved. This code does not save th
workbook.

Rolli
 
Adam,

Application.DisplayAlerts = False
Application.Quit

to close Excel without prompts, or omit the first statement to get prompts.

HTH,
Nikos

Adam said:
Dear all,

can someone please provide the VB macro code that will exit excel without
Click to expand...
prompt, also with prompts please. (Prompting meaning "Do you want to Save
book1.xls" etc.
 
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

Close all without saving and exit without prompts 8
How to get an Excel file to save without the VB 2
Macro to save and close, then copy file 2
Personal Macro 1
How To Exit Macro Without Debug Prompting 4
Excel Macro Save CSV Cell without Prompting 1
Excel file should not open book1.xls 4
Shared/Read Only WITHOUT Save prompt 3

Back
Top