autofilter in protected sheet

  • Thread starter Thread starter Tang
  • Start date Start date
T

Tang

I try to have a autofilter in a protected sheet using the following code:

Sub Protect_keep_filter()
With ActiveSheet
.EnableAutoFilter = True
.Protect DrawingObjects:=True, _
contents:=True, Scenarios:=True, _
UserInterfaceOnly:=True
End With
End Sub

However , it seem don't work for both Excel 2000 and Excel 2003.

Is there anyway to work about it?

regards
 
Is the AutoFilter in place?
Do you run the code when the the workbook is opened?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell color in protected sheet 1
AutoFilter with protected sheets 1
Workaround for disabled AutoFilter when sheet protected 5
assign button for color 9
Sort on Protected Worksheet 10
autofilter on a protected sheet 6
referencing multiple worksheets in macro 2
CHANGING POSITION OF AUTOFILTER LIST 3

Back
Top