Autofilter

[Mickey Mouse]

My worksheet consists of data from A to I and J

J1 contains an autofilter. Column J is unlocked

When I protect my worksheet I'm able to enter data in Column J
except for J1 where my Autofilter is. How can I access the autofilter
without unprotecting my worksheet?

Column J consists of quantities and I use the filter to display non empty
cells.

Mickey

 

[Mark]

This probably isnt exactly what you had in mind but it may be a
workaround that satisfies your requirements.

try inserting this code into your worksheet...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$J:$J" Then
Application.ActiveSheet.Unprotect
Range("J1").Select
Else
If Target.Address <> "$J$1" Then _
Application.ActiveSheet.Protect
End If

End Sub

Now if you want to be able to access your autofilter cell, just click
and select the entire "J" column. Hope this helps.