View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default Move worksheets to a new workbook

Hi Charles,

You can suppress the message by wrapping the line to delete the sheet in
these statements, as follows:

Application.DisplayAlerts = False
'delete sheet
Application.DisplayAlerts = True

Regards,
GS