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: 10
Default Workbook_SheetSelectionChange in an Addin

Hi,

I was wondering if someone could help me out. I've been trying to create an
addin for all our spreadsheets to create an audit trail writing each cell
change to a database, however, when I override the
Workbook_SheetSelectionChange procedure in the addin module, a cell change
never invokes the commands within the procedure.

It seems that the only Workbook_SheetSelectionChange code that it will
invoke is from ThisWorkbook or local code. Is it possible to create an addin
that will trigger an insert to a database with every cell change?

Thanks in advance,
Ryan
 
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
setup project for Excel addin, won't register addin Gerry Excel Programming 0 October 31st 07 12:01 AM
Workbook_SheetSelectionChange in going infinite sency Excel Programming 2 February 17th 07 05:44 AM
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai Brandon Excel Programming 0 June 27th 06 11:18 PM
Improving Workbook_SheetSelectionChange for enhanced Autofiltering aafraga[_2_] Excel Programming 5 April 10th 06 01:11 PM
Workbook_SheetSelectionChange R.VENKATARAMAN Excel Programming 3 January 23rd 05 11:44 AM


All times are GMT +1. The time now is 05:19 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"