I have a workbook with a number of links to workbooks on the Intranet. The problem is that you have to login through a loginbox.
When there are links in the workbook, Excel refuses to show me the loginbox, and instead shows a couple of error messages and then just put #REFs in all cells with those links.
My current solution is to have a "start" workbook, which first tries to open one of the files that demand password - so that Excel will show the loginbox. Then the start-workbook opens the real workbook, and when that's done, it closes it self.
I find this method rather ridiculous, so I just wonder if there are any other ways to solve the problem?
When there are links in the workbook, Excel refuses to show me the loginbox, and instead shows a couple of error messages and then just put #REFs in all cells with those links.
My current solution is to have a "start" workbook, which first tries to open one of the files that demand password - so that Excel will show the loginbox. Then the start-workbook opens the real workbook, and when that's done, it closes it self.
I find this method rather ridiculous, so I just wonder if there are any other ways to solve the problem?