J8sjskx98yyr
Automotive
- Jun 17, 2002
- 1
Excel doesn't always generate a SheetActivate event when a sheet's tab is selected. This is causing me problems. Does anyone know a workaround? The following steps reproduce my problem:
a) click on cell A1 on Sheet 1 and enter "="
b) click on the tab for Sheet 2
c) click on cell A2
d) hit the "Enter" key
At this point cell A1 on Sheet 1 is equal to cell A2 on Sheet 2. However, no SheetActivate event (or any other event for that matter) was generated on step "b". This is causing me problems.
In my particular application the cells of Sheet 2 may be updated at any time. If they happen to be updated at the time steps "b" or "c" are being performed, Excel locks up completely. If I could intercept through *any* event (SheetActivate event or otherwise) when step "b" occurred, I could prevent the cells from being updated on Sheet 2. But I can't since Excel didn't generate any events!
Any ideas?
Thanks,
a) click on cell A1 on Sheet 1 and enter "="
b) click on the tab for Sheet 2
c) click on cell A2
d) hit the "Enter" key
At this point cell A1 on Sheet 1 is equal to cell A2 on Sheet 2. However, no SheetActivate event (or any other event for that matter) was generated on step "b". This is causing me problems.
In my particular application the cells of Sheet 2 may be updated at any time. If they happen to be updated at the time steps "b" or "c" are being performed, Excel locks up completely. If I could intercept through *any* event (SheetActivate event or otherwise) when step "b" occurred, I could prevent the cells from being updated on Sheet 2. But I can't since Excel didn't generate any events!
Any ideas?
Thanks,