Hello All,
I’m creating a macro that will open some workbooks and copy the contents of sheets form workbook 1 to workbook 2.
Both workbooks are almost simulair and make use of the same named ranges.
Problem 1:
When opening one of the workbooks I get the message that some links are incorrect. That is okay, so I want to suppress this message, I don’t care.
Is it possible to suppress these messages when opening workbooks?
Problem 2:
Then when copying and pasting Excel is showing a message about the use of the named ranges and asks me if I want to use the named range of if I want to create a new name.
I want to suppress this messgae also, It should use the existing named ranges when pasting. How do I suppress these messages?
Thanks in advance for your answers.
