I want to know if it is possible to have a shared workbook with protected worksheet and an autofilter. I have tried with the user interface only option but after I save and reopen file, I can manually reset the autofilter but cannot do it via vba code.

Would appreciate any sample file if this is possible.

Thanks

    1 Response to "Shared Protected Workbook with Autofilter"

    • admin

      You can have a shared workbook with protected worksheet and an autofilter. I don’t really understand your question about resetting autofilter and cannot do it via vba code. You may want to give a more detailed example.

Leave a Reply