Reset Combox on Workbook Closing

[brentjohn]

Greetings,
I am using the following code to reset the combo boxes when I deactivate the worksheet and it works.

Please Login or Register  to view this content.

I am needing to reset the combo boxes when the workbook is closed as well - the workbook may be closed from this worksheet. I have tried the following code, but it does not reset the combo boxes.

Please Login or Register  to view this content.

I have also tried ComboBox1.Clear and it still does not reset the combo boxes.

[mehmetcik]

Your code needs to go into the "This Workbook" Macro Module.

[brentjohn]

mehmetcik,
I have Private Sub Workbook_Deactivate() in the "This Workbook" module.

[mehmetcik]

Please Login or Register  to view this content.

[brentjohn]

mehmetcik,
Thank you for your patience!
I had to modify your code by removing ".ActiveSheet". It still does not work. However, it works on Private Sub Workbook_Open(). I hope this can get resloved, or I will spend my weekend trying to figure it out....

Please Login or Register  to view this content.

[torachan]

Just a casual observation.
Could it be as simple as ????

With Worksheets("Summary_Report") OR With Worksheets("Summary Sheet")

[dotchiejack]

What about this?
Code goes in the ThisWorkbook module.

Please Login or Register  to view this content.

[brentjohn]

dotchiejack,
Thank you much!! It works perfectly!!
torachan,
You were correct as well!

[dotchiejack]

Glad to help and thanks for the rep.