Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening new workbooks | Excel Discussion (Misc queries) | |||
Opening specific worksheet from hyperlink more questions | Excel Discussion (Misc queries) | |||
Opening workbooks | Excel Discussion (Misc queries) | |||
Questions with 2 workbooks | Excel Programming | |||
Opening questions | Excel Programming |