I have a VB code that auto locks cells after data is entered when the file is saved, however I would like to maintain the Autofilter function on the locked sheet.
Normally when you Protect a Sheet you can 'Allow all users of this worksheet to:' - Use AutoFilter.
However the code that I am using (found out in cyberspace) just simply locks all cells with data in the named range. Is there something that I can add to the attached code to allow the use of AutoFilter once the named range has been protected?
Bookmarks