Spaces:
Sleeping
Sleeping
| ' ============================================================================= | |
| ' 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 | |