auto start code when a sheet is looked at

  • Thread starter Southern at Heart
  • Start date
S

Southern at Heart

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

Nick Hodge

Try specifically calling it

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change event code Find .Activate does not activate Target.value 4
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Array To View Specific Sheet(s) 2
Array code only works on selected sheet 14
Need to prevent call Sub Worksheet_Activate() during macro. 3
Trying to delete sheet code with VBA 2
Sheet activate question 4
Unhide sheet, copy and rename new sheets from list, rehide sheet 8

Top