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.
Dave
OzGrid Business Applications
