View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DS NTE DS NTE is offline
external usenet poster
 
Posts: 17
Default 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