How can I trick excel into thinking cell data has changed?

[rbac]

I have a macro that runs when a cell data changes and it works fine, however I want to have a button on the first sheet that will run this macro on every single page, i dont want to rewrite the whole crazy long macro from multiple pages into a button module, so i was thinking its easier if i just make excel think the data changed so it would run the macro to update it.

Here is what I have, but it seems to not work for whatever reason:

Please Login or Register  to view this content.

[rbac]

This is the code i have on 3 of the 4 tabs (the code on the 4th is a lot longer and more complicated, and it seems to be the same issue, just giving as example).

Please Login or Register  to view this content.

[JosephP]

Please Login or Register  to view this content.

should not compile or run-it oughta be

Please Login or Register  to view this content.

or simply

Please Login or Register  to view this content.

[rbac]

Thanks Josie,

It was running before, but this seems simpler anyway. It runs ok, but now the problem is, if you look at the other set of code I posted, it only seems to run the segment that ends up setting the one column to red/yellow 1, 2. For whatever reason it never will set the cells to 3 when I use the button, but when I activate it by changing the date normally, it works fine, i see no reason why this would happen.

Please Login or Register  to view this content.

should not compile or run-it oughta be

Please Login or Register  to view this content.

or simply

Please Login or Register  to view this content.

[rbac]

Magically all I did was change startrow in the module macro from 2, to 3, and it all works perfectly now... no idea why this would do anything signifigant like that.

[rbac]

wrong attachmenet