How to prevent change of Header/Footer information in excel 2003 file.

K

Kris

Hi.

Working on a file were people to enter numbers /
information, and I would like the Header/Footer
information to non changeble, does anyone know how to do
that.

Thanks
Kristian
 
K

Kenji

Kris,
Protecting the worksheet, workbook didn't work.

One thing I can think of is to set up the Page Headers with VBA each time
the Workbook is opened.. The user can change the header / footer if they
want, but the user cannot save it that way for others to print with
customized header/footer.

Kenjiro Yagi
http://www.spoofee.com
 
Top