Protecting a sheet with filters
 

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.

Protecting a sheet with filters
 

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).


--
Regards,
Tom Ogilvy



"Libby" wrote in message
...
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.