Try specifically calling it

Sub Worksheet_Activate()
Call Update_Materials
End Sub
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk




"Southern at Heart" wrote in
message ...
Can I have my code (that updates data on sheet("Materials") to
automatically
activate when the user selects that tab in the list of sheets?
I tried this:
Sub Worksheet_Activate()
Update_Materials
End Sub

where Update_Materials is the sub to do the work, but nothing happens when
I
flip between sheets...