Need vba script to look a worksheet and keep autofilter working

Hi all,

I need your help!
In Excel, I want to lock specific cells (not all) that I indicated as protected.
After protecting the worksheet however, only for the preselected cells, I still want to keep the autofilter feature for those columns that contain protected cells. This currently does not work

Could you show me which code I need to use?

Thanks,
Alinda

Hi,

try this:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True

Regards

Theo
__________________
Please consider:

Thanking those who helped you. Click the scales icon in the upper right corner of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

Many thanks Theo!