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