The print area is just a named range that users can set by choosing
FilePrint AreaSet Print Area.

You could use programming to set the print area before a worksheet
prints. For example, in the ThisWorkbook module:

'==================
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Worksheets("Sheet1").PageSetup.PrintArea = "$B$5:$D$15"
End Sub
'================

David McRitchie's has an intro to macros at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

art wrote:
Hi. Is there a way that I can lock the print area that I set. For E.G. if I
set the print area to cells B5:D15, is there a way to lock it so nobody
should be able to change it by mistake, and would have to unlock it to change
the print area?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html