Error message: "expected named parameter" when using AllowFiltering:=True

[acolmer]

Hi,

I'm a bit of a novice when VBA and have tried a macro that removes a password from a locked excel sheet, does an action and locks the sheet again with the password.

I seem to be unable to enable filtering and sorting, getting the error message "expected named parameter". Is anyone able to help? My code is below:

' DeleteRows Macro
'
'Sub ModifyProtectedSheet()
ActiveSheet.Unprotect Password:="****"
response = MsgBox("Are You Sure You Wish To Delete? Deleted Rows Cannot Be Recovered", vbYesNo)
If response = vbNo Then
MsgBox ("No Entries Deleted")
Exit Sub
End If

-> recorded process here

ActiveSheet.Protect Password:="****", AllowFiltering:=True<strike></strike>, AllowSorting:=True<strike></strike>,<strike></strike>

End Sub

Thanks for your help in advance!

 

[Fluff]

Hi & welcome to MrExcel.
Remove the comma from the end of the Protect line

 

[Peter_SSs]

Are you sure you have given us the correct code & error message? Fluff has pointed out the problem with the comma at the end of the Protect line, but that would produce a Syntax Error, not the error you have reported.

 

[Fluff]

Peter, I get the same error message as reported by the op.

 

[acolmer]

Thanks both - the removal of the comma worked!

 

[Peter_SSs]

Peter, I get the same error message as reported by the op.

Hmm, okay, I definitely got a Syntax error.
Anyway, the main thing is that the problem is fixed.

 

[Fluff]

Not sure why we would get different messages, but as you say the main thing is it's fixed.
@acolmer
Glad we could help & thanks for the feedback