Header and footers

  • Thread starter Thread starter Lloyd
  • Start date Start date
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
 
Hi
this would require VBA (processing the BeforePrint event of your
workbook). No easy way to do this
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Header/Footer w/ Worksheet Option Buttons 1
Headers and Footers by VBA? 6
report output format 1
Can I stop the footer from indenting? 4
Create header/footer txt file and link to Excel worksheets 1
Supress headers/footers first printed page 3
How do I insert the name of a named range in a footer in Excel? 2
Stripping Formating from Header/Footers 2

Back
Top