Thanks Leith, that was the first thing I tried, but it does not seem to
make any differnce at all- so I figured I must have been doing
something wrong.

here is some code associated with a button on the form, which I used to
test the code

Code:
--------------------

Sub filt_off()
Worksheets("DATABASE").Unprotect (pwd)
Worksheets("DATABASE").EnableAutoFilter = False
Worksheets("DATABASE").Protect (pwd)
End Sub

--------------------


If I run the code (i.e. click the button) nothing changes. I've checked
that the code is being executed and it definitely is, but it is doing
nothing?

Any idea why?


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=476079