I have a button on a worksheet that runs the CopySheet Macro:

Sub CopySheet()
ActiveSheet.Copy after:=Sheets(ActiveSheet.Index)
End Sub

It works fine for the first 25-30 times I use it, then it starts giving
me the following error:

Run-time error '1004'
Copy method of Worksheet class failed

When I shutdown and restart excel, it works again for 25-30 times.

Does anybody know why this would stop working?