Hi All,
Have been struggling with this for a while now!
A range of cells have drop down lists (N14:N25) that determine the value of a cell (M3).
Change of Value of cell M3 Triggers macro to Hide/Unhide on another sheet.
Issue :
• Selection of any of cells in N14:N25 results in macro firing – should only fire if M3 changes.Please Login or Register to view this content.
Note – Once this issue resolved separate Worksheet Change Calculate will be assigned for each cell in range M2:M8Please Login or Register to view this content.
Attached file as example.
Would appreciate any help!
Bookmarks