This is a problem in Excel 97 and 2000, which was fixed in 2002 and 2003.

http://support.microsoft.com/default...45&Product=xlw

The only thing I can suggest is to use a button or perhaps an object like a
text box, that is made to look like a hyperlink, and attach a macro to it.
The macro can activate the target sheet and cause the activate event code to
run.

--
Jim Rech
Excel MVP
"DJH" wrote in message
...
|I have a macro that I would like to perform whenever a
| worksheet is activate. Using the Worksheet Activate event
| accompished the required macro when the sheet is activates
| by selecting the sheet.
|
| My problem is that when a hyperlink is used to select the
| worksheet, it's Activate event does not occur. How can I
| get around this?
|
| Thanks to all for any help.