<div>
This guy figured it out:<br />
<br />
<a href="http://www.mrexcel.com/forum/showthread.php?t=333961" rel="ugc">http://www.mrexcel.com/forum/showthread.php?t=333961</a><br />
<br />

</div>


<div>
I think you can also do it with custom views, but have not tested.
</div>


<div>
<div class="content wysiwyg-content">
I currently run code that unfilters the spreadsheet when an a particular form pops up. Is it possible to save the filter criteria prior to the form popping up and then return to that criteria after the form is down with the unfiltered spreadsheet?
</div>
</div>


I currently run code that unfilters the spreadsheet when an a particular form pops up. Is it possible to save the filter criteria prior to the form popping up and then return to that criteria after the form is down with the unfiltered spreadsheet?

How to return to a previous filter setting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.