Links in spreadsheet

P

PeterW

Hello.

I need to open a series of spreadsheets in a directory, copy a worksheet
from each and paste the worksheet into a new spreadsheet.

All of this I can do, but the spreadsheets I have to open have links to
other spreadsheets that cause the 'Update?' message box to appear.

Is there a way to send a 'don't update' response click, or any other way to
get around the message box?

Thank you for your help.

PeterW
 
G

Guest

hi,
try this....

Application.DisplayAlerts = False
'your code here
Application.DisplayAlerts = True

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Detect if file exists 5
Copying (variable) rows from another spreadsheet 1
Excel Spreadsheet display with autorefresh 1
Bypassing password protection in Visual Basic 9
Significant DELAY to open spreadsheets containing regular links? 6
Problems with incorrect linked values 5
Converting MS query from Excel 2003 to Excel 2007 1
Sub Workbook_Open not called when opening spreadsheet 6

Top