Command button error

I created input userform. Eachtime i input any information in the userform and when i close the userform i should able to see the corresponding information in the excel row. But the excel is not doing auto filter which made me to create autofilter in the vb close button. But the issue is when i click close button in excel it taking atleast 4 mins to update each information. Does any one know why ? the code is below,

private Sub CommandButton2_Click()
Unload Me
Worksheets("TPM FORM").Activate
ActiveSheet.AutoFilterMode = False
UserForm1.Hide
End Sub
Thanks

Why are you hiding the form when you have already unloaded it, that will cause it to re-instantiate then hide.