Closing the Print Dialogue box

[vvaidya]

Hi:
I would appreciate help with the following:

I have placed code in the Workbook Before Print Event, to alert the
user by displaying a messagebox, if Cell A1 is left blank. The message
states something like this:

"Please enter name in cell A1 before printing this sheet"

Next, I would like to prevent the user from printing the sheet if cell
A1 is blank.

What additional line of code do I need to add so that the "Print
Dialogue" box closes or does not appear at all, thus preventing the
user from printing if cell A1 is left blank?

TIA
Would appreciate your help with the code

Thanks
Vinay

 

[Rob Bovey]

Hi Vinay,

Set the Cancel argument of the event procedure to True to cancel
printing.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[vvaidya]

Thanks
It worked!
V