just to the left of File on the menu bar, select View Code and paste in
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Const pw As String = "xyz" '<<< change to suit
If InputBox("Enter password to print") <> pw Then
MsgBox "Wrong password - printing cancelled"
Cancel = True