Couple of possibilities:

because you (or a workbook/add-in you've opened) have disabled events
with

Application.EnableEvents = False

or because the code is not in the correct worksheet module

or because macros are disabled...



In article ,
ExcelMonkey wrote:

It does not do anything. I just want proof that the macro is firing. And
its not firing. Even if I put a break in, it does not fire. I can't seem to
get any examples to work. Why would this be?