Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint
Workbook with several worksheets. I want actions performed
BeforePrint but only if either WS1 or WS2 are active. If WS1 is active, MsgBox YesNo "Is blah blah...?" If yes, just print, if no, open dialogue box with 2 labels (questions) and 2 text boxes. When both text boxes are completed and OK'd, in WS1 cell X99, put [capitalised text of text box 1] comma space [capitalised text of text box 2], print If WS2 is active, MsgBox YesNo "Is blah blah...?" If yes, just print, if no, open dialogue box with 2 labels (questions) and 2 text boxes. When both text boxes are completed and OK'd, in WS2 cell X99, put [capitalised text of text box 1] comma space [capitalised text of text box 2], print If any other WS active, just print |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforePrint | Excel Programming | |||
BeforePrint | Excel Programming | |||
BeforePrint help | Excel Programming | |||
ADO 2.7 & ADO 2.8 beforeprint | Excel Programming | |||
Help with BeforePrint | Excel Programming |