I got this error, too. I, also, did have a button that was linked to a procedure which was named like the module it was in. After i renamed the module, the error occurred. I had a version before my changes so tried some things.

What finally worked was:

• After the error already occured:

  • copy all your code into a textfile, remove the button and the module. Save. Close. Open. Create a new Module with a correct name and paste your code. Create the button. You have to close Excel/VBA or the error will persist.

• Before renaming the module:

  • Delete the Button. Save. Close. Open. Rename the Module. Create the button. Here, too, you have to close Excel/VBA in between.

I hope this helps!