Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
disable Warnings in Excel
I created a database that exports data in an excel workbook. I would like to
delete Tabs from access to Excel. When I do delete the Tabs on Excel. Excel throws out a warning are you sure you want to delete this tab. How do I turn off the warnings? I have the security is low as it can go. Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
disable Warnings in Excel
In code?
In excel, I'd use: application.displayalerts = false 'delete the worksheet application.displayalerts = true If you're automating excel from access, you'll have some variable that represents the excel application, right? xlapp.displayalerts = false 'delete the worksheet xlapp.displayalerts = true Crazyhorse wrote: I created a database that exports data in an excel workbook. I would like to delete Tabs from access to Excel. When I do delete the Tabs on Excel. Excel throws out a warning are you sure you want to delete this tab. How do I turn off the warnings? I have the security is low as it can go. Thanks in advance for any help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warnings | Excel Discussion (Misc queries) | |||
how to protect without getting the warnings | Excel Worksheet Functions | |||
how to protect without getting the warnings | Excel Worksheet Functions | |||
Warnings when entering formulas in Excel | Excel Discussion (Misc queries) | |||
Disabling some MS Excel warnings. | Excel Discussion (Misc queries) |