Protecting a sheet with filters

  • Thread starter Thread starter Libby
  • Start date Start date
L

Libby

Hi,

I've been told that you can't protect a worksheet that has
filters on it. Having tried it, it does seem that when
the sheet is protected the filter button is unclickable.
Is there anyway to protect a sheet and still be able to
use filters?

Thanks in advance.
 
Set the sheet property EnableAutoFilter (you can use the properties
button on the Control Toolbox Toolbar to do this).

Put the filters in place

then protect the sheet.

This much be set each time the sheet is opened (it can be done with code).
 
Back
Top