Protecting print area?
 

Is it possible to lock the print area somehow in an Excel document?

Thanks

I don't know of any way to lock the print area. You could add code to
the workbook's BeforePrint event, and set the print area there.

However, if users don't enable macros, the print area won't be set.

For instructions on storing and using macros, you can read David
McRitchie's notes:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Sabrina D wrote:
Is it possible to lock the print area somehow in an Excel document?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html