Automatically Trigger Event when Cell Changes

Hi, I'm trying to create a drop-down menu of sorts that is available in every page of the worksheet. I have the value of every page's drop down box linked to a hidden spreadsheet that uses a vlookup table to give a value based off of what "menu option" is chosen with the "default" option yielding a value of 0. I have the sum of all of the pages' numerical values in a cell on this spreadsheet and would like to create a macro that triggers whenever this cell (containing the sum) is not equal to 0. The cell that is going to be triggering the macro when not equal to 0 will be on the hidden page (MACRS Loans) and therefore not active. The Run Reset_menu at the bottom of the code runs a macro that changes all of the drop down boxes back to their default value after the page is changed in order to reset the macro. Below is what I have so far in VB, the macro works when manually executed but not automatically when the cell is changed. Any help would be much appreciated, Thanks!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The above code has to be in the relevant worksheet module
Note that the macro won't trigger unless the enter key is pressed

Hi, Thinkslow,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Ciao,
Holger