One way around it (if you know macros are enabled and events are enabled) is to
plop the header/footer information into each worksheet using the
workbook_beforeprint event.

But this isn't foolproof, either.

ChemistB wrote:

I work in a Federally regulated environment. The Header and footer are
open to change even when the workbook and sheets are password
protected. The only solution I see is to embed the footer information
directly into the spreadsheet.

Bill Gates should also make it possible for the author of a spreadsheet
to lock in the header/footer information and the Spreadsheet options.
:-/

--
ChemistB
------------------------------------------------------------------------
ChemistB's Profile: http://www.excelforum.com/member.php...o&userid=12741
View this thread: http://www.excelforum.com/showthread...hreadid=498379

--

Dave Peterson