Macro used to work, but now refusses..

B

Bitsbb01

Joined
Apr 9, 2012
Messages
2
Reaction score
0
Ok i have this in the section by right clicking the sheet 1 tab, then entering these details into it...

However for awhile it was working correctly, however since we've been working on it the last few days, the change code is not running...

Any idea why it's no longer running?

Code: 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Column = 46 Then ' Collumn AT
    ThisRow = Target.Row
    Application.EnableEvents = True
    If ActiveCell.Value <> "Y" Then ' They have a list box..
      Run "Worksheet_Calculate2" ' Macro to run the 2nd part..
    Else
    msgbox "You Clicked N, so you must still be filling it in.. "
     End If
  End If
Application.EnableEvents = False
End Sub

Thanks in advance
 
Last edited:
Back
Top