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
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