|
Hi David,
The monsoons have arrived with a bang, and thanks for that lovely suggestion about the Belgium trip.
As for your case, the macro will be triggered only for changes in column A. And secondly, you need to enable the macros while starting the workbook (provided the security is medium). If the security is low, then the macros will start automatically, and if high, the macros will be disabled automatically.
Another reason why the macro might not work is probably because the macro given by Bob did not complete its run (probably due to exiting pre-maturely) and hence the EnableEvents was not turned back to true.
Mangesh
|