Hi. I am developing several add-ins in tandem and find that the SheetChange causes complication because it fires no matter which add-in you are using. I was thinking of just foing a straight Excel 2007 Workbook application instead. What are the advantages of doing it this way?
Private Sub Application_SheetChange(ByVal Sh As Object, ByVal Target As Microsoft.Office.Interop.Excel.Range) Handles Application.SheetChange