Maybe...
Private Sub Worksheet_Change(ByVal Target As Range)
If me.range("dailyupdate").value = True Then SortThem
End Sub

DailyUpdate is a named range (single cell) on the same sheet?

Scottie wrote:

Group,

I have a worksheet change evenet that I want to be able to toggle with a
named cell value.

Private Sub Worksheet_Change(ByVal Target As Range)
If dailyupdate = True Then SortThem
End Sub

NO errors, but it doesn't run.......I am totally lost as to how to fix
it.... I know there is something missing

If the value is false, I want it to just fail and stop.

Please help :)

Thanks in advance.....

Scottie

--

Dave Peterson