Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hoi,
I'm using a macro to copy data from file-1 to file-2. In file-2 (which is not my file) an automatic ChangeEvent is build in by another person on such a way that when I copy data to a specific datafield I get an automatic popup with a question. It's not allowed for me to change this code, but............ I don't want that pop-up when I'm copying data into it. Is there a way I can disable that code when I'm copying. Something like: 'disable code for AutoEvent..... 'copy data 'enable code for AutoEvent.... below the code which I found in that file-2 as I mentioned. Private Sub Worksheet_Change(ByVal Target As Range) Dim ChangedRange As Range Set ChangedRange = Range("I25:I33") If Union(Target, ChangedRange).Address = ChangedRange.Address Then CheckResult '=run another macro End If End Sub regards, Johan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet_Change Event | Excel Programming | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
Worksheet_change event | Excel Programming | |||
Worksheet_Change Event | Excel Programming | |||
Worksheet_Change Event | Excel Programming |