Questions upon opening workbooks
 

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!

Questions upon opening workbooks
 

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!

Questions upon opening workbooks
 

Thank you - this took care of problems #1 & 3, and I was
able to use the same idea to solve problem #2 - I found
Application.AskToUpdateLinks.

Thanks again!

-----Original Message-----
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!


.