Protecting the print area

  • Thread starter Thread starter C Pogue
  • Start date Start date
C

C Pogue

Is there a way to prevent readers from resetting the print
area, or of keeping them from printing a range of cells on
a worksheet? I'm new at this.
 
You could use something like this in thisworkbook module, it will set the
print area on sheet 1 before the sheet prints
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").PageSetup.PrintArea = "$A$1:$F$7"
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top