To protect the data in a worksheet but still allow users to use the autofilter function, use VBA to set the "userinterfaceonly" argument of the sheets.protect method to "true"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.