Try this
![]()
Private Sub CommandButton3_Click() Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets WS.Protect AllowFiltering:=True Next WS End Sub
Try this
![]()
Private Sub CommandButton3_Click() Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets WS.Protect AllowFiltering:=True Next WS End Sub
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks