VBA Code to Protect Worksheet with Allow Filtering in Excel

This code protects the active worksheet, allowing users to apply and change filters but preventing other modifications.

VBA Code:

Sub ProtectWorksheetAllowFiltering()
    Dim password As String
    
    password = InputBox("Enter the password:")
    ActiveSheet.Protect Password:=password, AllowFiltering:=True
End Sub

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment