VBA代码有时可以工作，但有时不能在表格格式的工作表中的自动筛选行上工作

Private Sub CommandButton2_Click()
.
.

Set ws1 = Sheet1
ws1.Activate 'I'd like to see the sheet that's why I activate it. It's not a bad practice.
ws1.Columns.Hidden = False
ws1.Rows.Hidden = False
ws1.AutoFilter.ShowAllData
.
.
Private Sub CommandButton2_Click()
.
.

Set ws1