Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_SheetSelectionChange in an Addin
You addin has to instantiate Application Level events. Chip Pearson shows
you how at http://www.cpearson.com/excel/appevent.apsx you would then use the application level version of the event you speak of. it will pass in a reference to the sheet that triggered the event Private Sub object_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) -- Regards, Tom Ogilvy "rchan11" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_SheetSelectionChange in an Addin
All workbooks is a pretty large number! You may want to limit your code to
certain workbooks (based on name or location or a hidden name or ...). But the type of event you're looking for is called an application event. You can start by reading Chip Pearson's notes: http://www.cpearson.com/excel/AppEvent.aspx rchan11 wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_SheetSelectionChange in an Addin
Thanks Tom and Dave for your quick responses! I'm relatively new to Excel
Programming so I'll give those 2 comments a try. Thanks again, Ryan "Dave Peterson" wrote: All workbooks is a pretty large number! You may want to limit your code to certain workbooks (based on name or location or a hidden name or ...). But the type of event you're looking for is called an application event. You can start by reading Chip Pearson's notes: http://www.cpearson.com/excel/AppEvent.aspx rchan11 wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setup project for Excel addin, won't register addin | Excel Programming | |||
Workbook_SheetSelectionChange in going infinite | Excel Programming | |||
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai | Excel Programming | |||
Improving Workbook_SheetSelectionChange for enhanced Autofiltering | Excel Programming | |||
Workbook_SheetSelectionChange | Excel Programming |