Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Autofilter on Protected sheets
Hi,
I am having trouble using autofilter once I protect my worksheets. I run a mcaro and the code is below. I am using Excel 2003 and ticking the auto-filter box when I protect the sheet aswell but once I save & close the sheet and reopen to test, it doesn't allow me autofilter and sheets are protect and will not allow any changes. Can someone help please. Sub ExceptionsDays() ' ' Dim MyDate As Date, StringDate As String With Sheets("Daily Sheet") StringDate = InputBox("Enter Date") If IsDate(StringDate) Then MyDate = DateValue(StringDate) .Range("E2") = MyDate Else MsgBox "Invalid Date" Exit Sub End If Sheets("Daily Sheet").Unprotect Password:="yogin" .Range("$B$4:$D$1000").AutoFilter Field:=1 .Range("$B$4:$D$1000").AutoFilter Field:=4 .Range("$B$4:$D$1000").AutoFilter Field:=4, Criteria1:="DEX" .EnableAutoFilter = True Sheets("Daily Sheet").Protect Password:="yogin" .EnableAutoFilter = True Sheets("Daily Sheet").Select End With End Sub Thanks Yogin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
Using Autofilter on a Protected Worksheet | Excel Discussion (Misc queries) | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
Autofilter on protected work book? | Excel Discussion (Misc queries) | |||
Autofilter on protected workbook | Excel Discussion (Misc queries) |