Macro: Exit active workbook without save?

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

Guest

How to create a maco button that exit the active workbook without saving?
Thanks
 
Hi
try
sub foo()
with activeworkbook
.saved=true
.close
end with
end sub
 
Thanks to both of you for the quick responses. I did get your responses but
have been unable to get back on this site until tonight to thank you.....my
apologies for the lateness of this thank you but know your help is greatly
appreciated.

Don
 
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

Need VB formula to exit workbook 1
Close all without saving and exit without prompts 8
Excel Providing user message when RED X clicked & properly closing application. 2
HOW TO EXIT ACTIVE WORKBOOK 1
Troubleshooting macro to save in Compatability Mode 2
What comes after Windows 10? 15
close workbook without saving or promt to save 3
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0

Back
Top