sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 585
- Office Version
- 365
- Platform
- Windows
This is a general question about a warning I keep getting every time I open my workbook. I get a banner across the top of my screen like the one below every time I open my workbook. So when I click on the "Manage Workbook Links" button, it allows me to go ahead and refresh.
I did add the line of code below to the Workbook Open event and when it opens the file it is telling me that I need to select a different sheet for one of my external links because the one it is showing doesn't exist. I cannot find anyplace where this sheet is even referenced in my file or code as a wrong sheet.
Thanks, SS
I did add the line of code below to the Workbook Open event and when it opens the file it is telling me that I need to select a different sheet for one of my external links because the one it is showing doesn't exist. I cannot find anyplace where this sheet is even referenced in my file or code as a wrong sheet.
VBA Code:
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinksThanks, SS
