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.
Private Sub Worksheet_Calculate()
Static oldval
If Range("M3").Value <> oldval Then
oldval = Range("M3").Value
Call HideUnhideRCPT
End If
End Sub
ThisWorkSheet code set as :
Private Sub WorkSheet_Open()
PrevVal = Sheet7.Target = Range("M3").Value
End Sub
Note – Once this issue resolved separate Worksheet Change Calculate will be assigned for each cell in range M2:M8
Attached file as example.
Would appreciate any help!
Bookmarks