Posted to microsoft.public.excel.programming

ADK

external usenet poster

Posts: 89

AutoFilter with protected sheets

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AUTOFILTER IN A PROTECTED WORKSHEET	William	Excel Discussion (Misc queries)	1	August 22nd 08 10:27 PM
Using Autofilter on Protected sheets	Yogin	Excel Discussion (Misc queries)	3	August 3rd 08 05:30 PM
Protected Sheet and AutoFilter	Steven	Excel Programming	2	September 15th 06 02:13 AM
Using Autofilter on a Protected Worksheet	Brendan Vassallo	Excel Discussion (Misc queries)	1	March 31st 06 01:08 PM
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?	StargateFanFromWork[_3_]	Excel Programming	6	January 26th 06 06:31 PM

All times are GMT +1. The time now is 09:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us