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