The autofilter is disable using the userform

[Joseph Pagan]

My problem is with the autofilter
What is my problem?
when i use the find button in a userform created in VBA, the autofilter is
disable automatically in the worksheet without my intervention the close
button disable too the autofilter in the worksheet.
What is my question?
How i can Troubleshooting my application to never disable the autofilter
when the users use the userform especially the find button and the close
button

 

[Joseph Pagan]

i post here my code :
http://www.mrexcel.com/forum/showthread.php?t=393635

I too long to post here but there you can download or only see the code.
Thanks.

 

[Patrick Molloy]

delete this:-

If Sheet1.AutoFilterMode Then Sheet1.Range("A7").AutoFilter

which is the last code line in sub Button8_click

 

[Joseph Pagan]

I delete the line but give a error when i use the find button.