| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto start code when a sheet is looked at
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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto start code when a sheet is looked at
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of values that need to be looked up from another sheet | Excel Worksheet Functions | |||
| Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
| Auto transfer rows from 1 sheet to another by account code. | Excel Worksheet Functions | |||
| Code for auto filling in Excel based on number of months, & start date | Excel Programming | |||
| Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Linear Mode
