Impossible to close excel without saving message in internet explorer

  • Thread starter Thread starter tinftinf
  • Start date Start date
T

tinftinf

Hello
Does someone knows how prevent the dialogue box for saving when I leave
an excel sheet opened in internet explorer ?
The use of "ThisWorkbook.Saved = True" in the event "Before_close" has
no effect with internet explorer

Thanks
 
Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
 
JLGWhiz a écrit :
Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
Click to expand...
Thank you for the input but it isn't efficious : IE ask for saving
before the event VBA 'before_close'
 
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

Addin not allowing thisworkbook.save in before save event 3
Apparently not possible? 8
Close excel in vbe 3
Excel Providing user message when RED X clicked & properly closing application. 2
Handling internet explorer memory leaks from Excel VBA 0
addin running in different Excel instances 7
Copy from Excel to Word 2
Closing without saving and without asking the user to save...or no 3

Back
Top