ExcelBanter - Header and footers

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Header and footers (https://www.excelbanter.com/excel-programming/298294-header-footers.html)

Lloyd

Header and footers

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

Frank Kabel

Header and footers

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

--
Regards
Frank Kabel
Frankfurt, Germany

Lloyd wrote:
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

All times are GMT +1. The time now is 06:06 AM.