When exiting a document and "open a form" button macro automatically turn off autofilter

[cath1509]

Hi all! So i have two problems -

Firstly, I have a code that when you press save on a document, my spreadsheet turns off the autofilter before saving. However I have noticed that when people press Exit then when prompted select save - the autofilter is NOT turned off. I would like the autofilter to turn off no matter how i save the document.

Here is the code:

Please Login or Register  to view this content.

The second problem is that on my workbook there is a button that you press called the caller button which opens up a form to populate my spreadsheet. The issue that I am having is that I would like when you press this button the filter turns OFF, then the form appears. I tried to adapt my above code to do this, but it doesn't seem to be working:

Please Login or Register  to view this content.

Thanks very much!

[LJMetzger]

Hi cath1509,

Try the following (tested and working using Excel 2003).

Problem 1.
In the ThisWorkbook Module:

Please Login or Register  to view this content.

Problem 2.
Add the following line after Worksheets("Sheet1").Activate:

Please Login or Register  to view this content.

Lewis