Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trigger worksheet activate event in another worksheet
Hi,
I have some code written in the worksheet activate event of Worksheet1. This creates a pivot table in Worksheet2 and writes some other data to Worksheet1 based on this pivot table. I want the same thing to happen when Worksheet2 is activated ie the code in Worksheet activate event Iin Worksheet 1 should run, create the pivot table in Worksheet2 and then write the data in Worksheet 1. Any ideas on how to do this? Specifically, can I use Worksheet2's activate event to activate Worksheet 1 whose code should then get triggered? Will it result in an infinite loop. In which case, how do I break the loop. Thanks in advance for the help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Activate event if only one sheet in book | Excel Programming | |||
Msgbox in worksheet activate event if design mode is turned off | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
Worksheet Activate Event | Excel Programming |