Suppress column heading on blank pages

[GregTheGeek]

I have searched the threads and have found nothing along these lines.

I have an Excel workbook that contains 14 worksheets, including a table of contents. Each worksheet, when printed, is between 1-5 pages. When printing the entire workbook back-to-back, I need each worksheet to start on the right. I have found no better way of doing this than to insert a blank page at the end of each worksheet with an odd number of printed pages. The net effect, however, is that the "Rows to repeat at top" (column headers) shows up on the blank pages, as would be expected.

Does anyone know of a way to keep these headers from printing if the page is blank? If it comes down to it, I would rather have them print than use code to solve the problem (which I know I can do, I even have a pretty good idea on how). Here's why: this file will be shared by many people across the company. I want to avoid confusion and frustration on the users' part by avoiding the macro security warning.

Your help is appreciated!

GTG

 

[SkipVought]

GTG,

You're asking a SPREADSHEET application to do what a WORD PROCESSOR application is designed to do.

It's like saying, I'm using a knife to do the job of a screwdriver, but I don't want it to cut me.

There's not way that I know of, to get into the PRINT MANAGER, to override the Heading/Footind logic.

However, you could write a macro that would print each PAGE in each SHEET for each SHEET in the WORKBOOK, separately, but you would have to keep track of the page numbers, and you would have to format each Header/Footer in accordance with your specifications.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}