Unwanted loop

Hey!

Let's say you have two workbooks opened and you want to run a macro everytime the "workbook 2" is deactivated. However, the macro should make some changes to this deactivated "workbook 2" and then deactivate it again. But this scenario obviously creates an infinite loop.

My "workbook 2" code looks like this:

Please Login or Register  to view this content.

My Macro:

Please Login or Register  to view this content.

Is it possible to make it work without this unwanted loop?

Thanks for any advice!

Lukas

Thanks for the reply!

To better understand what I'm trying to accomplish with this, please take a look at my older thread:
http://www.excelforum.com/excel-gene...33#post3328333

So, I have two workbooks opened. The first one is a database and the second one is a workbook, where I'm using some comboboxes to select the values from the database. However, everytime I sort some of the database columns, my comboboxes selections are messed up. Because of this, I would like to run this COPY/PASTE macro everytime I switch from the second workbook to this database workbook, so I have those comboboxes selections stored in other cells, in case I would like to sort anything in the database, and later I want to run another macro to paste them back after I sort something in the database workbook.

Does it make sense?

Thanks in advance!