Not sure what the culprit is with your workbook. It could be some kind of corruption.
I have copied the sheets to a new book and attached a generic macro to your shape.
This works and I hope you can start from there.
General recommendation: Put your macros in a separte modul (as done in the attached book) and leave the sheet module for code related to WorksheetEvents.
Hope this helps
Richard
Bookmarks