Cyberdude
03-03-2006, 10:34 AM
I must have 10 or 15 different workbooks that have Worksheet_Change events working just fine, but I am trying to set up a new workbook to have a Worksheet_Change event, and it just won?t trigger.
I placed the following code into the module for worksheet ?Main?:
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Test " & Target
End Sub When I add a value to a cell in worksheet ?Main? or I change the value in a cell there, absolutely nothing happens. I have changed the cell value directly on the worksheet, and I have used a macro to change a cell value. Neither triggers the event. I included the statement
Application.EnableEvents = True
in the macro I executed just in case events were turned off. No help.
I?m stumped. What am I missing?? :dunno
I placed the following code into the module for worksheet ?Main?:
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Test " & Target
End Sub When I add a value to a cell in worksheet ?Main? or I change the value in a cell there, absolutely nothing happens. I have changed the cell value directly on the worksheet, and I have used a macro to change a cell value. Neither triggers the event. I included the statement
Application.EnableEvents = True
in the macro I executed just in case events were turned off. No help.
I?m stumped. What am I missing?? :dunno