It is telling you that it has accessed a sheet that does not contain the button. Perhaps you can check first to see if the button exists, and if it does, then destroy it!
(Change for your language, but theory still same!):
if "CommandButton1" != NULL
I have said it once, I will say it again. IT!