Warning message before saving

[Ldg2009]

I have a excel spreadsheet with filters when someone saves it with a filter on it messes up the file. Does anyone no what code Ican use so when someone goes to save the file it shows "have all filters been removed? yes goes to save and no cancels the request?

thanks

 

[MARK858]

Why not just remove the filter before the save if a filter is applied rather than give a message?

 

[JoeMo]

You can use a Workbook_BeforeSave event macro. This could be written to remove any filters from the specific worksheet or worksheets so the user doesn't have to be informed. However, macros and events must be enabled or it will not work.

 

[Ldg2009]

Its not me saving it its a file used by a lot of people who seem to forget the filter by having a warning message they have no exxcuse to save with filters on

 

[Ldg2009]

Anyone know the best way to write it? I tried it in editor but didn't quite work correctly I must've wrote it wrong

 

[MARK858]

It is still the same question. Why give them a messagebox rather than force an autosave eliminating the filters?
Please explain your thinking.

 

[Ldg2009]

Sorry So the filters would still be in place to use but when saving removes the filter?

 

[MARK858]

You can remove the filters totally or leave the filter dropdowns with no filter applied.

 

[Ldg2009]

The filters need to stay to search for specific information which was why I wanted the warning message