Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Print depending on tab colour | Excel Discussion (Misc queries) | |||
objects (buttons, dropdown list) move after print | Excel Programming | |||
Populating dropdown list 2 with data depending upon what was selected in list 1 | Excel Programming | |||
Changing cell value depending on dropdown list | Excel Programming |