Protection with filters?

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Using XL 2000

I have posted in programming aswell because i'm open to
solutions.

I have a workbook containing 3 worksheets.
I need a to prevent users from editing Worksheet1 but
allow the filter functionality.

Any ideas?

Thanks, Paul
 
Hi Paul
depends on your Excel version. In Excel 2003 I have the option to
protect a sheet ('Tools - Protection') and check 'allow autofilter'
 
Back
Top