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...

Try specifically calling it

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




"Southern at Heart" <(E-Mail Removed)> wrote in
message news:2F08AED1-B8A5-47AB-87EE-(E-Mail Removed)...
> 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...
>