LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Event Procedures in an Add-In


Hi all

I am using the Workbook_SheetSelectionChange event to determine when
range is selected and to show the total, average and number of item
selected. This works great in a workbook, but I have tried to set thi
up in an add-in so it's availale all the time, but it doesn't wor
because the event is tied to the add-in file and not the currentl
active workbook.

Does anybody know of a way around this?

Thanks

DJ

--
DJ
-----------------------------------------------------------------------
DJB's Profile: http://www.excelforum.com/member.php...fo&userid=2122
View this thread: http://www.excelforum.com/showthread.php?threadid=46838

 
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
Event procedures for controls added with CreateEventProc John Austin[_6_] Excel Programming 7 March 24th 05 03:21 PM
learning event procedures R.VENKATARAMAN Excel Programming 4 January 21st 05 01:09 PM
Event procedures (and the temple of doom) Mark Tangard[_3_] Excel Programming 2 July 20th 04 04:45 PM
Event Procedures: Event on Worksheet to fire Event on another Worksheet Kathryn Excel Programming 2 April 7th 04 07:35 PM
Creating Event procedures from a macro Robert Stober Excel Programming 3 September 7th 03 06:52 PM


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

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"