Header and footers

L

Lloyd

Does anyone know how to show a filter that is applied in
the spreadsheet, into a footer? so it is easy to see when
printing out that a filter has been applied? without
manually typing it!

Regards

Lloyd Young
 
F

Frank Kabel

Hi
this would require VBA (processing the BeforePrint event of your
workbook). No easy way to do this
 
Top