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.

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.

Thanks

That was my alternate solution, but I thought maybe I
could get the hyperlink to activate a worksheet somehow...


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

http://support.microsoft.com/default.aspx?scid=kb;en-
us;162045&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.


.