View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Problem closing a workbook using a macro

Hi Steve,

Is there anyway of just closing the file without being
asked all these questions ?


Su

ActiveWorkbook.Close SaveChanges:=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com