MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Filter won't work

Posted by Randy Evans on February 07, 2001 8:52 PM

When the worksheet is protected. Can this be changed?
When protected the Auto Filter selection is grayed out and inaccessable.

Posted by Dave Hawley on February 08, 2001 12:30 AM

Hi Randy

The only way you can is via VBA and use:

Sheet2.Protect Password:="secret", UserInterFaceOnly:=True

This will allow changes to a protected sheet via VBA but not via the interface.

The only other option is to apply sheet protection and uncheck Contents.


OzGrid Business Applications