Thread: BeforePrint
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default 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