Remove Filters on close

[b50]

Hello all,

I have a slight problem. I have an excel that is uploaded on Share Point and my problem is when someone uses it they are filtering it and when they are done they are saving it with the filters. So the next time someone opens the file they are seeing the person's filters that were previously on.

What I was wondering was if there was a way that I could set up excel to remove the filters when it closes? I would like to do this without using a macro, but if that is the absolute only way then could someone help me write it?

Thank you!

[JBeaucaire]

This macro placed in the ThisWorkbook module will execute on close.

Please Login or Register  to view this content.

You could put that into a _BeforeSave() event instead. Or you could edit it to only refer to the one specific sheet.

[b50]

Awesome I figured there was a simple macros to solve this problem, but is there anyway to do it without a Macro, so that everyone doesn't have to enable macros?

[b50]

I tried the code you gave, and I get:

Compile Error:

Procedure declaration does not match description of event or procedure having the same name.

[JBeaucaire]

Sorry, forgot to look at a standard event sample for any required parameters. Try this:

Please Login or Register  to view this content.