Try preceding your code with
Application.DisplayAlerts = False
and reset to True after.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"E. Edgington" wrote in message
...
I am using VBA that copies all worksheets from several
workbooks into one workbook. Problem is, Excel asks me
about ten questions before the code is finished. Is
there a way to make VB answer these questions so the end
user never sees them?
The actual questions/statements a
1. A formula or sheet you want to move or copy contains
the same name 'NvsEndTime', which already exists on the
destination worksheet. Do you want to use this version of
the name? Y/N
2. The workbook you opened contains automatic links to
information in another workbook. Do you want to update
this workbook with changes made to the other workbook? Y/N
3. The selected sheet(s) will be permanently deleted.
OK/Cancel
As always, thanks for your help! You guys are AWESOME!