| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro that runs when worksheet is automatically updated
I have a workbook that has a worksheet (Sheet1) for user entry. This updates
another worksheet (Sheet2) automatically with information specific for that part number as defined in Sheet1. I have a macro that puts a picture in Sheet2 and it works beautifully except I need it to run when the information from Sheet1 changes Sheet2 automatically. How can I make that macro run whenever I switch to Sheet2. (Sheet1 has data entered....Sheet2 automatically has field changes...needs macro to run whenever switching to Sheet2 to view the data). Thanx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro that runs when worksheet is automatically updated
Lets assume that you macro (called lambi) is in a public module.
In the worksheet code area for Sheet2 insert: Private Sub Worksheet_Activate() Call lambi End Sub -- Gary''s Student - gsnu200755 "Lambi000" wrote: I have a workbook that has a worksheet (Sheet1) for user entry. This updates another worksheet (Sheet2) automatically with information specific for that part number as defined in Sheet1. I have a macro that puts a picture in Sheet2 and it works beautifully except I need it to run when the information from Sheet1 changes Sheet2 automatically. How can I make that macro run whenever I switch to Sheet2. (Sheet1 has data entered....Sheet2 automatically has field changes...needs macro to run whenever switching to Sheet2 to view the data). Thanx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro that runs when worksheet is automatically updated
Worked like a charm. Thanks for the code.
"Gary''s Student" wrote: Lets assume that you macro (called lambi) is in a public module. In the worksheet code area for Sheet2 insert: Private Sub Worksheet_Activate() Call lambi End Sub -- Gary''s Student - gsnu200755 "Lambi000" wrote: I have a workbook that has a worksheet (Sheet1) for user entry. This updates another worksheet (Sheet2) automatically with information specific for that part number as defined in Sheet1. I have a macro that puts a picture in Sheet2 and it works beautifully except I need it to run when the information from Sheet1 changes Sheet2 automatically. How can I make that macro run whenever I switch to Sheet2. (Sheet1 has data entered....Sheet2 automatically has field changes...needs macro to run whenever switching to Sheet2 to view the data). Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WHY the same macro runs so slowly on a different but faster comput | Excel Discussion (Misc queries) | |||
| One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
| User to decide how often a macro runs | Excel Discussion (Misc queries) | |||
| Macro that runs in the background | Excel Discussion (Misc queries) | |||
| Which Macro Runs...? | Excel Discussion (Misc queries) | |||
Linear Mode
