Activating a worksheet

[DJH]

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.

 

[Jim Rech]

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

 

[djh]

Thanks

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