Auto filters and locked protected sheet

[wmtsub]

Is ther some way to protect a worsheet so ppl can not write/delete data but still can use the colum filters to sort and search?

 

[kpasa]

Here's an example I use for Protecting a sheet with VBA:

[COLOR=#333333]ActiveSheet.Protect [/COLOR][B][COLOR=red]Password:="YourPassword",[/COLOR][/B][COLOR=#333333] DrawingObjects:=True, Contents:=True, Scenarios:=True _
[/COLOR][COLOR=#333333], AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True[/COLOR]

Then if you want to unprotect via VBA use:

[COLOR=#333333]ActiveSheet.UnProtect [/COLOR][B][COLOR=red]Password:="YourPassword"[/COLOR][/B]

 

[wmtsub]

Thank you, yes, got that far last night. ​

Stuck right now on getting it to allow me to sort. I can search but not use the sort function. The worksheet is a Table, would that have any effect?
I replaced my code with yours and it worked the same, wont let me sort.

 

[wmtsub]

Bump.... I can nto ge the sort funtion to work when the sheet is protected. Is it because it is a table?
If so is ther some way to work around that?