Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Can I Use a filter on a protected Worksheet

Posted by Nola Scott on October 03, 2001 7:43 AM

Is it possible to create a usable filter for a protected worksheet and link the effected range to another protected worksheet?

When I tried the filter became disabled. I would very much appreciate your help.

Re: Can I Use a filter on a protected Worksheet

Posted by Barrie Davidson on October 03, 2001 8:15 AM

Nola, you could only filter a protected worksheet via VBA (unprotecting the worksheet, applying the filter, and then protecting the worksheet). Can you clarify what you mean by "link the effected range to another protected worksheet".

Regards,
BarrieBarrie Davidson

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.