I want to run a routine that updates a graph when a specific cell is changed
At the moment, I can't get the Workbook_SheetChange to fire
To test it, I put the following in the sheet containing the cell that is changed by the user, just taken from the VBA help file
Private Sub Workbook_SheetChange(ByVal Target As Range)
MsgBox ("A change in cell " & Target.Address)
Then to try to make sure events are enabled, I put the following in the Workbook area
Private Sub Workbook_Open()
Application.EnableEvents = True
I saved the file and reopened it, which I presume will have triggered EnableEvents but nothing happens whe I change the value in the sheet concerned, or any other value on that sheet.
How do I get Workbook_Open to be triggered?