AutoFilter with protected sheets

A

ADK

I have two sheets with autofilter. The code below works for the one sheet.
How can I list the two sheets in this code? Using Excel 2000Private Sub
Workbook_Open()
'check for filter, turn on if none exists
With Worksheets("Data")
If Not .AutoFilterMode Then
.Range("A1").AutoFilter
End If
.EnableAutoFilter = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub
 

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

CHANGING POSITION OF AUTOFILTER LIST 3
Autofilter, protected worksheets, Debra Dalgleish's code 2
Autofilter protected sheet 4
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
CHANGING POSITION OF AUTOFILTER LIST 4
Advanced Filter Error - I cannot spot my Error 3
Change definite value to string reference for criteria 1
Multiple ranges to Auto Filter 1

Top