Deactivate worksheet code during paste

[swaink]

Hi All
I have code in a worksheet that highlights the entire row when the user selects a cell.

However when I try to paste new data to that sheet using a macro the macro fails because of the active worksheet code.

Is it possible to suspend the worksheet code whilst another macro is running then re activate it on completion?

Many thanks

Kevin

 

[Derek]

Hi
Yes, you need to put a condition at the beginning of the code such as:
If Range("A1").Value = 77 Then
(rest of code)
End If (add this after your code)

Then it will only be active whilst the value of A1 is 77 (or whatever you choose)

hope this helps
regards
Derek

 

[Ivan F Moala]

On 2002-03-22 03:03, swaink wrote:
Hi All
I have code in a worksheet that highlights the entire row when the user selects a cell.

However when I try to paste new data to that sheet using a macro the macro fails because of the active worksheet code.

Is it possible to suspend the worksheet code whilst another macro is running then re activate it on completion?

Many thanks

Kevin

Application.enableevents=false

then the rest of your code....

application.enableevents=true


ivan

 

[Derek]

Thanks Ivan, that's much neater than mine
regards
Derek

 

[swaink]

Thats fantastic guys many many thanks

Regards

Kevin