In a xlsm workbook I have an auto open macro that opens a different workbook that has a user form with multiple buttons linked to the master workbook. The user form workbook has no macros, only links to all my VBA code. This was updated from a very old Excel project.
When the user form book opens it gives the error message: "This workbook contains one or more links that cannot be updated". If you click the "Continue" button everything is fine. If you click the "Edit Links" button you see the master workbook and under status it says "Unknown" even though the book is open though hidden. (This was not an issue in older Excel).
If you click "Check Status" the status updates and says "Open" and you continue. So nothing goes wrong but I don't want my clients to have to click continue every time they start the program.
I have set AskToUpdateLinks - DisplayAlerts to false. Used On Error Resume Next but nothing stops the bogus error.
All suggestions welcome!
When the user form book opens it gives the error message: "This workbook contains one or more links that cannot be updated". If you click the "Continue" button everything is fine. If you click the "Edit Links" button you see the master workbook and under status it says "Unknown" even though the book is open though hidden. (This was not an issue in older Excel).
If you click "Check Status" the status updates and says "Open" and you continue. So nothing goes wrong but I don't want my clients to have to click continue every time they start the program.
I have set AskToUpdateLinks - DisplayAlerts to false. Used On Error Resume Next but nothing stops the bogus error.
All suggestions welcome!
