Print/Not print depending on dropdown list value

[Guest]

Hi, I'd like to print (or not print) a particular printing page in a
Worksheet when printing depending on the selection of a dropdown list, where
the list contains "YES" or "NO" created using data validation. Is this
possible? Thanks

 

[Guest]

Hi Sam:

You need to use a workbook event before print as in:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
if activesheet.name="sheet1" then

' may need to change this
if activesheet.range("A1") = "NO" then
Cancel=true
end if
End Sub