View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Close with no pop-up?

Thanks Lonnie, that worked just great!!

Vaya con Dios,
Chuck, CABGx3


"Lonnie M." wrote:

Hi, try something like this (Assuming that the workbook is the active
workbook):

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True

HTH--Lonnie M.