Workbook Deactivate event problem

J

Jeremy Strom

Hi,

The issue I am having is easily reproducible I think (I'm using Office
2003):

1. Create two files: Book1.xls, and Book2.xls.
2. In Book1.xls, add any code to the Workbook_Deactivate event. I've
used this:
Private Sub Workbook_Deactivate()
n = 1 + 1
End Sub
3. Change any cell in both workbooks (anything that will trigger a
save prompt on exit).
4. Activate the workbook that does not contain the deactivate event
(Book2.xls).
5. Close the application using File --> Exit.

It will prompt you to save both documents. If you hit Yes to both
prompts, it will then do NOTHING. Then if you select File --> Exit
again, both files will save and close with no prompts.

I've looked around for a solution but so far haven't found anything.
Has anybody seen this before or know why it does this?

Thanks!
 

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

xlfTextRef from another workbook 1
BeforeSave sub won't save another workbook when triggered by another event sub 1
Macro to compare, find match and copy between workbooks 6
Closing Workbook then Activating Other Wb with Userform showing? 1
BeforeSave event fired but not working when triggered by SaveAs. 3
not your average activate event 5
Save problem with multiple workbooks and event workbook_deactivate 2
All Workbook Saved except This Workbook 3

Top