Simple button suddenly make excel crash on saving,then replace with new one and work, why?

Hello everyone,

So i got a few macros on a worksheet and one of them is simply :

Sub Pr_Removefilter()
ActiveSheet.ShowAllData
End Sub

Ive worked on the excel a couple of times, everything fine. Then it started crashing upon saving (after changes made that had no possible connection to the macro, on another sheet). After a few painfull trials and errors i located the problem to be this macro button. I erased it, created a new one with the EXACT macro and it works. Why?...

I want to avoid such future problems, anyone have idea on what could cause this?

Thanks a lot!

Any help or tips? Please