I dont think you are doing anything wrong. I think the 2007 version does not have the type of autofilter feature that I previously described. I have attached a working version of the idea. This worksheet will only work to filter the first column. If you look at the code by pressing ALT + F11 when the workbook is open you can see that the code is very very basic. You dont need to worry too much about the if statements those are just in there so the program does not error out.
You will have to excuse my older version of office I use a lot of different options and this computer happens to have 2003. Let me know how it works out or if you have any questions.

Thanks

Attached Files

FilterWorksheet.xls (59.0 KB, 21 views)