How can you in VBA protect an Excel worksheet while allowing users to select slicers and sort columns but keep the headers locked? 

I have to set the Contents to False in the worksheet Protect method, so the users can select the slicers. However, this does not protect my headers. If I set Contents to True in the Protect method, the headers are locked, but you cannot select any slicers.

Any help will be greatly appreciated. Thank you!

​How can you in VBA protect an Excel worksheet while allowing users to select slicers and sort columns but keep the headers locked?  I have to set the Contents to False in the worksheet Protect method, so the users can select the slicers. However, this does not protect my headers. If I set Contents to True in the Protect method, the headers are locked, but you cannot select any slicers.Any help will be greatly appreciated. Thank you!  Read More

​