Code to not display delete sheet alerts
 

I am trying to run code in Access to delete sheets in
Excel. I do not want the alerts to pop up that I am
deleting sheets. I thought the syntax
was "WorkbookName".displayalerts = false. When I run it
though VBA does not know it as a valid command. Does
anyone know the right syntax??

Thanks,
John

Code to not display delete sheet alerts
 

Application.Displayalerts = False (?)

"John" skrev i melding
...
I am trying to run code in Access to delete sheets in
Excel. I do not want the alerts to pop up that I am
deleting sheets. I thought the syntax
was "WorkbookName".displayalerts = false. When I run it
though VBA does not know it as a valid command. Does
anyone know the right syntax??

Thanks,
John

Code to not display delete sheet alerts
 

John,

The command is

Application.DisplayAlerts= False

regards,

(another) John


"John" wrote in message
...
I am trying to run code in Access to delete sheets in
Excel. I do not want the alerts to pop up that I am
deleting sheets. I thought the syntax
was "WorkbookName".displayalerts = false. When I run it
though VBA does not know it as a valid command. Does
anyone know the right syntax??

Thanks,
John