disable Warnings in Excel

  • Thread starter Thread starter Crazyhorse
  • Start date Start date
C

Crazyhorse

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.
 
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
 
Back
Top