Does anyone know if I can suppress footers when printing?

B

BPC123

I want my footers to show when using as workpapers but when wanting to print
the final report, I want to be able to suppress them?
 
J

Jim Thomlinson

There is no built in option to supress footers. You could use a macro to add
or remove the footers.
 
G

Gord Dibben

You could clear the footers before printing but would have to reset them
after.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.CenterFooter = ""
End With
End Sub

Sub CellInFooter22()
With ActiveSheet.PageSetup
.LeftFooter = "&""Algerian,Regular""&16" & Range("A1")
'adjust the format and content to suit.
End With
End Sub


Gord Dibben MS Excel MVP
 

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

Can I suppress printing a line if a value = 0? 3
suppress printing on certain rows 7
Building closed workbook file path within an Index Function 6
Printing footers 3
Suppress footer if opened from subreprot 1
Footer font resize when "fit to page" 1
Suppress Report Footer 4
What I believe is a Watermark 4

Top