I think you'll find the best approach is to just go and look (or wait until
someone complains and fix it then).

And if you're prompted with "this workbook contains macros" and you think you
removed all the code (in all the modules), take a look at Debra Dalgleish's
site:

http://www.contextures.com/xlfaqMac.html#NoMacros

She has some nice instructions with pictures.

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



--

Dave Peterson