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.
Bookmarks