I don't think you can (well, not through xl2003 anyway).

The best I can do is create a macro that changes all the headers and footers on
each worksheet to what I want -- each time the user prints (or print previews).

And if they disable macros or disable events, my macro won't work.

You might want to get your management involved and make it a training issue.

nice_evest wrote:

Dears,
I'm making an Excel Sheet tempalte where i'm using my Comnay's logo and our
own built eader and footer.
i protected the sheets, cells from being edited and allowed some. i also hid
some functions... etc
what i actually need is to protect my customized header and footer from
being manipulated by anyone.
i couldnt disable the page setup command or do anything to it via coding,
maybe i wasnt coding right.
please advise me on doing the header\ footer protection. it's really
necessary.

the easiest the way the better :-D

Many thanks :)

--

Dave Peterson