I have a spreadsheet that was created in an earlier version of Excel
and is now being used in Excel 2007 with compatibility mode on. One
of the macros filters the data on the sheet, using the autofilter
command, based on selections the user has made via a pop-up form.
Previous to Excel 2007, this was working fine. Now it appears the any
command lines following the autofilter command are ignored. Has
anyone encountered a similar situation?