DISALLOW PRINTING IF CELLS ARE INCOMPLETE

[RBrown]

I've been trying to find the correct code to disallow printing when certain cells are left blank. The problem I'm having is the cell contents will have in some cases both letters and numbers, as in serial numbers (3KZ00525) or dealer codes (D050).
Any help would be greatly appreciated

[DRJ]

Hi - Welcome to the board

Put this code in the thisworkbook section of vbe

Private Sub Workbook_BeforePrint(Cancel As Boolean)

    If Range("A1").Value = vbNullString Then
        Cancel = True
        MsgBox ("Fill out the information for A1"), vbCritical
        Else
    End If
    
End Sub

[RBrown]

That is it Thanks so much!!!!