Print/Not print depending on dropdown list value
 

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

Print/Not print depending on dropdown list value
 

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

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Sam Kuo" wrote:

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