Dave

There is no global Office setting that would control the Headers/Footers for
workbooks/worksheets.

Possibly your workbooks were based upon a Template that had the code, but if
most other workbooks don't have it, the Template is no longer being used as
the basis for new workbooks.

Delete the code from the module for this file and save.

To find the "lingering" ones would require manually checking each workbook or
using Chip Pearson's "remove all VBA code" which may be overkill and dangerous
if you have other code you need to keep.

For reference see.... http://www.cpearson.com/excel/vbe.htm


Gord

On Fri, 25 Feb 2005 06:47:05 -0800, "Dave Breitenbach"
wrote:

The before workbook was exactly right. I think I recall someone at our
offices setting this up for all workbooks - but most other ones no longer
have it... this must have lingered for some reason. How could I confirm that
no other spreadsheets have lingered with thee headers? Is there a location
in office settings which could affect all workbooks? Also, I should simply
remove the code in this one right?

thanks to both of you,
Dave

"Gord Dibben" wrote:

Dave

How do you remove it in the Print Preview Window?

You must select "Setup" from the PP window to access the Headers/Footers
dialog.

Remove from there.

If keeps coming back, maybe you have some code that is replacing it.

Like Before_Print code in the ThisWorkbook module.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 13:35:43 -0800, "dave" wrote:

I have a header which keeps coming back after I remove it
in the print preview window. Does anyone know why this
might be happening?

tia,
Dave