R
robzrob
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
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