Thread
:
Move worksheets to a new workbook
View Single Post
#
8
Posted to microsoft.public.excel.programming
GS
external usenet poster
Posts: 364
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
Reply With Quote
GS
View Public Profile
Find all posts by GS