Thanks Nick,

I closed the file and re-opened it. That seemed to reset whatever was
hanging up. It works now.
--

JonR


"NickHK" wrote:

Then validation triggers a WorkSheet_Change event.
Unless events have been disabled. Maybe due to a partial running of your
code ?
We are talking about Excel's Data Validation ?

NickHK

"JonR" ...


Excel 2000, running on XPPro

JonR


"Bob Phillips" wrote:

Excel 97?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JonR" wrote in message
...
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