| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off confirmation messages via VBA
In xl2000 and later, I believe
xlApp.DisplayAlerts = False ' delete the sheet xlApp.DisplayAlerts = True should work. In earlier versions, I believe you had to put code in the workbook and execute it to make the setting changes. -- Regards, Tom Ogilvy "LB" wrote in message ... I have an Access program that I built to manipulate an Excel workbook. One of the things I need to do is supress the confimation messages when I delete a worksheet via the code. I know I can supress these messages in Access, but I'm not sure how to accomplish that in Excel. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn off text box for confirmation of paste command ? | Excel Discussion (Misc queries) | |||
| Confirmation ID provided? | New Users to Excel | |||
| Turn off confirmation messages via VBA | Excel Programming | |||
| Getting rid of confirmation boxes | New Users to Excel | |||
| Confirmation of file | Excel Programming | |||
Linear Mode
