Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoid Update Links dialog in Excel 2003 | Links and Linking in Excel | |||
How to avoid an error dialog | Excel Programming | |||
avoid warning when removing sheet | Excel Programming | |||
How to I Avoid the Auto-Email Security Warning | Excel Programming | |||
How-To suppress a warning dialog | Excel Programming |