Lock a print area

[Guest]

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 B515, 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]

The print area is just a named range that users can set by choosing
File>Print Area>Set 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

 

[Guest]

thanks for the answer but I tried it and it didn't work. Maybe I didn't put
in the macro the right way. Any help?
Is there a way to print just one sheet and not another sheet and set that
way that it should be locked?

 

[Debra Dalgleish]

The macro goes in the ThisWorkbook module. David McRitchie describes how
to install them Her:

http://www.mvps.org/dmcritchie/excel/event.htm#blueboxWS

If macros are enabled, the sample code will automatically run when you
print Sheet1.