#1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BeforePrint joeeng Excel Programming 1 November 7th 08 11:17 AM
BeforePrint Robin Clay Excel Programming 4 February 13th 07 03:48 PM
BeforePrint help Rookie 1st class Excel Programming 4 November 19th 05 09:57 PM
ADO 2.7 & ADO 2.8 beforeprint JCanyoneer Excel Programming 7 March 30th 05 04:05 PM
Help with BeforePrint Eric[_7_] Excel Programming 2 October 9th 03 07:44 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"