Read only table - How to allow filtering?

[Jaymond Flurrie]

Everytime I active a sheet, I print a summary to there. Then I protect this sheet, so that it becomes a read-only sheet.

The protection comes like this:

Sheets("Summary").Protect Password:="apassword", UserInterFaceOnly:=True

Now I would still want the user to be able to use the table filtering features ie. I'd like to allow them to hide and show rows, which happens by these normal table functions Excel provides by clicking the dropdown button on the header row. How do I implement that "partial protection"? Anything smarter than monitoring the activecell and protecting/unprotecting by whether a single cell from Row1 is selected?

 

[Andrew Poulsom]

Try setting AllowFiltering to True.

Sheets("Summary").Protect Password:="apassword", UserInterFaceOnly:=True, AllowFiltering:=True

 

[Jaymond Flurrie]

Try setting AllowFiltering to True.

Sheets("Summary").Protect Password:="apassword", UserInterFaceOnly:=True, AllowFiltering:=True

Thanks, does exactly what I wanted!