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