Deactivate worksheet code during paste

swaink · Mar 22nd, 2002, 04:03 AM

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 · Mar 22nd, 2002, 04:14 AM

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 · Mar 22nd, 2002, 04:22 AM

Quote:

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 · Mar 22nd, 2002, 04:52 AM

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

swaink · Mar 22nd, 2002, 04:56 AM

Thats fantastic guys many many thanks

Regards

Kevin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 04:03 AM	#1
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	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

Mar 22nd, 2002, 04:14 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Mar 22nd, 2002, 04:52 AM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Thanks Ivan, that's much neater than mine regards Derek

Mar 22nd, 2002, 04:56 AM	#5
swaink Board Regular Join Date: Feb 2002 Location: South UK Posts: 344	Thats fantastic guys many many thanks Regards Kevin