' ============================================================================= ' DO NOT use File → Import on this file. ' Open ThisWorkbook in VBA, then paste ONLY the procedure below. ' ' After updating AmazonUrlCleaner.bas: remove the old module, re-import the new ' AmazonUrlCleaner.bas, then ensure ThisWorkbook still has Workbook_SheetChange. ' ============================================================================= Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) On Error GoTo ErrorHandler HandleAmazonUrlSheetChange Sh, Target Exit Sub ErrorHandler: Application.EnableEvents = True End Sub