Enabling Events

**kosherboy** · 03-22-2016, 10:59 PM

The code below is a simple event procedure that when the word "Hi" is typed ina specified range then that "target cell" changes automatically to the word "Works!" Unfortunately this doesn't always work, for example if i type a different word after the word "Hi", then the code doesn't execute in the next instance. Also, the code won't work when i open the workbook, to get it to work i need the events to be enabled again via a different macro.

Please Login or Register  to view this content.

All help on this would be greatly appreciated

**InvisibleMan** · 03-23-2016, 12:17 AM

You have your True and False the wrong way round. False at the beginning, True at the end.

**kalbasiatka** · 03-23-2016, 12:30 AM

for what you need to disable events?

Please Login or Register  to view this content.

**InvisibleMan** · 03-23-2016, 03:33 AM

for what you need to disable events?

Because he's making a change to a cell value within a worksheet change event handler. That will cause the event handler to fire again. No big deal here but could be a bad habit to get into.