View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_56_] Andrew[_56_] is offline
external usenet poster
 
Posts: 130
Default How to avoid warning pop-up dialog boxes

Hello,
I have a purchase order template which has a bunch on vendor
information on sheet 2, while the actual purchase order form is on
sheet 1. I have a button on screen which is called "create PO". When
I press this button, the program re-names the worksheet as PO-
(addnumber), and then deletes the second sheet, which contains all of
the vendor information. So, when the program tries to delete sheet 2,
it sends a pop up dialog which requires the user to press OK or
Cancel. How can I have the program skip this pop up box?

thanks