I have a macro that re-filters the information in the column when I add new information in a different sheet. it works great but i have the code in all 28 sheets that does this and it really slows down my excel is there a way to make it into a macro that will apply to the entire workbook?
Sub Refilter()
If Me.FilterMode = True Then
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
With ActiveWorkbook
.CustomViews.Add ViewName:="Mine", RowColSettings:=True
Me.AutoFilterMode = False
.CustomViews("Mine").Show
.CustomViews("Mine").Delete
End With
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
End If
End Sub
Moderators Note: Please follow forum rules and use code tags. Added for you this time, but please use them in the future…Thanks.
Bookmarks