<<<"The Header and footer are open to change even when the workbook and
sheets are password
protected."

That's *not* true.

You can protect the WB from even being *opened* without a password if you
choose.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"ChemistB" wrote in
message ...

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