View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vvaidya@pol.net is offline
external usenet poster
 
Posts: 24
Default Closing the Print Dialogue box

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