jmenche
02-14-2007, 01:35 PM
Howdy,
I have a macro that copies a bunch of data into a sheet. It will be used over and over. I also have a worksheetchange event to handle sorting after the data is copied in. However, I wrote the worksheetchange event with a static data set. Now, when I run the macro, the worksheetchange event fires in the middle and screws up the macro. Can I turn the event off until the macro is done??
:beerchug:
I have a macro that copies a bunch of data into a sheet. It will be used over and over. I also have a worksheetchange event to handle sorting after the data is copied in. However, I wrote the worksheetchange event with a static data set. Now, when I run the macro, the worksheetchange event fires in the middle and screws up the macro. Can I turn the event off until the macro is done??
:beerchug: