PC Review


Reply
Thread Tools Rate Thread

AutoFilter on a protected worksheet

 
 
ADK
Guest
Posts: n/a
 
      13th Jul 2007
I have two worksheets which I have defined the columns with AutoFilter. I
have the sheets protected. When a user opens the sheet they can use those
predefined filters. I currently have the following code in WorkBook_Open. Is
this code even required ...if so is what I have correct?

Occasionally, the AutoFilter pull-downs stop working for some reason.
Current fix is to exit workbook and re-open it ....Auto-filters are fine

Using Excel 2000


Private Sub Workbook_Open()
On Error GoTo addError
With Worksheets("PDSR")
If Not .AutoFilterMode Then
.Unprotect Password:="12345"
.Range("A66").AutoFilter
End If
.EnableAutoFilter = True
.Protect Password:="12345", _
Contents:=True, UserInterfaceOnly:=True
End With
With Worksheets("CompletionTable")
If Not .AutoFilterMode Then
.Unprotect Password:="12345"
.Range("C6:I6").AutoFilter
End If
.EnableAutoFilter = True
.Protect Password:="12345", _
Contents:=True, UserInterfaceOnly:=True


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Autofilter on a Protected Worksheet =?Utf-8?B?QnJlbmRhbiBWYXNzYWxsbw==?= Microsoft Excel Misc 1 31st Mar 2006 01:08 PM
autofilter in protected worksheet? Kate Microsoft Excel Worksheet Functions 4 20th Jul 2004 11:45 AM
Autofilter in protected worksheet Gustavo Microsoft Excel Misc 2 28th May 2004 12:54 AM
AutoFilter on Protected Worksheet JanetW Microsoft Excel Misc 1 22nd Jan 2004 10:01 PM
autofilter in protected worksheet Ki Microsoft Excel Misc 3 13th Oct 2003 12:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:19 AM.