Hi

How do you disallow row deletion, when auto filter is active?

Rich

the question is more likely how to you allow autofiltering when the sheet is
protected. If the autofilter is already in place (the arrows are visible),
you can then do

with Worksheets("Sheet1")
.EnableAutofilter=True
.Protect Password:="ABCD",UserInterfaceOnly:=True
End With

This will allow the arrows to be used to filter the data while protection
remains.

You need to run this code whenever the workbook is opened or you are going
to apply protection. The userinterfaceonly property can only be set in code.

You might want to use the Workbook_Open event to run the code.

See Chip Pearson's overview of events if you are not familiar with them

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"RMJames" wrote:

Hi

How do you disallow row deletion, when auto filter is active?

Rich