Hello,

I have a macro residing in a module which needs to modify the value of a global variable declared and residing in sheet 1 code.

When I click a button, the associated macro edits a cell and then calls the worksheet change event in sheet 1, at this point, the
worksheet change event sets a GlobVar to 1. Which is ok because it is harmless under this context.

However, when the worksheet change event completes it comes back to my macro which I must reset GlobVar to 0 like this:

GlobVar = 0

Then the next time the worksheet change event gets called by other changes, I would expect to see GlogVar to 0 but I don't and
GlobVar is still 1.

Why why !!!

GlobVar is declared as Public!!!!!!

Anyone know why this is happening

RN