Alert/warning

[mpc2123]

Hello.

I have a workbook that I would like to display a quick warning if the data is still filtered when I attempt to save or print. For context, we often use filters while constructing the document and then the client will receive the pdf as the product. Every now and again it gets pdf'd while one or multiple columns have been filtered w/o someone noticing and the client receives an incomplete version of the schedule. Is this possible?

 

[StephenCrump]

Welcome to the Forum!

Two suggestions:

1. Have a warning cell that tests whether, say, COUNT(A:A)=AGGREGATE(3,5,A:A) and, if not, displays a warning message: "Make sure you unfilter before you print or save!"

2. If you're happy to use VBA (?) write code for the Workbook_BeforePrint and Workbook_BeforeSave events to turn filtering off before the print/save happens.