How do I use AutoFilter when Protection is on?
Posted by Donald A Barron on June 27, 2001 12:24 PM
I am stuck. I have no idea how to use Macros or VBasic or Script Editor, or any of that. My question is, can I use the AutoFilter drop down box when Protection is on? I know I can uncheck contents and that will work but I am trying to get around that for if someone accidentally hits "delete" then the cell is lost if the person does not know what they are doing. I figured out how to use validate to restrict new data to be inputted into the area but not how to restrict it from the delete command. Can anyone help?