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

How to avoid warning pop-up dialog boxes
 

Using the following line of code at the top of the sub/function that deletes
the sheet:

Application.DisplayAlerts = False

--
Kevin Backmann


"Andrew" wrote:

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

How to avoid warning pop-up dialog boxes
 

try

Application.displayalerts=false
your code to delete sheet
Application.displayalerts=True

Mike

"Andrew" wrote:

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

How to avoid warning pop-up dialog boxes
 

On May 23, 12:41 pm, Mike H wrote:
try

Application.displayalerts=false
your code to delete sheet
Application.displayalerts=True

Mike

"Andrew" wrote:
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

Thanks. That worked just fine.