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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Help with events 6
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Problem with macro in Excel VBA working across sheets 1
Vba Vlookup Problem 0
Change_Event troubles, no error & no work. 6
VBA Worksheet_Change not working on new sheets. 2
Change_Event not responding to change made by formula. 11

Top