View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_46_] John[_46_] is offline
external usenet poster
 
Posts: 7
Default 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