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

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

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

art wrote:
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" wrote:


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





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