Hi

I'm trying to program a sheet to automatically refresh (run a refresh macro)
whenever the value of cell D5 is updated. D5 is set up as a validated list,
where the allowed values are a list of dates. A drop-down list enables the
desired date.

Here's what I have so far. For some reason, the code doesn't execute when a
new value is selected in the drop-down.

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

Refresh 'macro that updates & sorts the information on the page

Application.EnableEvents = True

End Sub

Thanks in Advance

JonR