Using check box to control Autofilter

[Carlsbergen]

Hi.

I have assigned a macro to a check box.

When the check box is "ticked" the option (blanks) is used in the Autofilter.
This then filters out any rows that has anything written in
So far so good..


Now the question: Is it possible to make the Autofilter use (All) when the checkbox is "un-ticked"?


EDIT:

Nevermind!

Here is how to do it if anyone else wanna know:

http://en.allexperts.com/q/Excel-105...-vs-Macros.htm