stopping change in cell from refiring worksheet change

cogswel__cogs

Board Regular
Joined
Jan 3, 2018
Messages
184
Hi
I have worksheet change code that make adjustments based on certain cell changing.

After one particular cell change I catch the target value and put it into data area,
Afterward I want to replace the target cell with a formula. But when I paste in the formula it refires the workcheet change code again.
Is there a way to shut off the workheet change macro while the code is running?

All help is greatly appreciated.
 
Hi
I have worksheet change code that make adjustments based on certain cell changing.

After one particular cell change I catch the target value and put it into data area,
Afterward I want to replace the target cell with a formula. But when I paste in the formula it refires the workcheet change code again.
Is there a way to shut off the workheet change macro while the code is running?

All help is greatly appreciated.

EnableEvents will enable you to control the firing of the worksheet change event procedure.

VBA Code:
Application.EnableEvents = False
' Code to run here.
Application.EnableEvents = True
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top