SheetActivate event not triggered by PF5 (goto) range on different sheets.

H

hscowan

Hi,

I just noticed that the SheetActivate event is not triggered by PF
goto ranges on different sheets. The same happens if the sheet i
changed by selecting a named range in the drop-down list of the "Nam
Box".

I'm using Excel 2000 on top of XP.

Is this a known issue, any workarounds, etc?

thanks,
Scot
 
Top