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.

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