LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
djh djh is offline
external usenet poster
 
Posts: 8
Default Activating a worksheet

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Find Data in another Worksheet without activating it? HumanJHawkins Excel Worksheet Functions 2 July 31st 09 11:35 AM
Finding Worksheet and Activating it Rob Excel Discussion (Misc queries) 2 January 30th 07 08:14 PM
Activating a Worksheet? Kenny R Excel Discussion (Misc queries) 3 December 8th 06 05:15 PM
Activating a worksheet through use of a variable Cads Excel Worksheet Functions 2 February 7th 06 10:45 AM
Subscript our of range when activating a worksheet J.E. McGimpsey Excel Programming 0 October 7th 03 07:12 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"