Filter

M

Mati

I am using a sheet with lots of filter
Is it possible to lock one of the filter (after filtering), in a way that users can operate other filters without the ability to use the locked filter

Thanks for your hel

Mat
 
D

Debra Dalgleish

You can do this with a macro. In this example, the dropdown for column 2
is hidden:

'================================
Sub HideOneArrow()
Range("A1").AutoFilter Field:=2, _
Criteria1:="Ontario", _
Visibledropdown:=False
End Sub
'===========================
 
D

Dave Peterson

This might not be important, but I could still do:
Data|filter|ShowAll

and kind of use it.
 
Top