Steven,

One way which still allows users to set up their own print range is to set
up your print and page settings as you require and then using the menu

usually add the following VBA code and attach to a button that then prints
the sheet as per my setting.  A user could change the Custom View but most
don't know of this.

Hope this is of some use,
Rob

Sub PrintCustomView()
On Error GoTo ErrorMsg
'Enter the named custom view to print in place of PrtRg
Const Cview As String = "PrtRg"
ActiveWorkbook.CustomViews(Cview).Show
ActiveWindow.SelectedSheets.PrintOut 'or PrintPreview
Exit Sub
ErrorMsg:
MsgBox "Error encountered, likely wrong Custom View name.", , "Error"
End Sub