See Ron de Bruin's site for code to prevent printing the footer on first page.

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 12:50:01 -0700, MLS at LPC <MLS at
wrote:

I have a 4 page .xls worksheet. Since I will be adding a coversheet before
faxing the worksheet to others, I want to change the footer from Page 1 of 4
to page 2 of 5. I know how to use Page Setup to change the start number, but
need to know how to change the last page number.