Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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.

Re: Auto Filter won't work

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.