Desktop Word 2016 desktop?
Mail merge: start in Word and import a contacts mail folder.
Upgraded to 2016, something happened. Licences changed etc.
Logged in to SP / Office 365 as TractusContacts and the contacts are there.


I have a macro-enabled file (let's call it "Timecard.xlsm") that has formulas that link to another file. The other file is named "test.xlsx" and is password-protected.

I have the following code in the timecard file, and I've tried it both in a module as "Auto_Open" (as is shown here) and in the "ThisWorkbook" object with the open event (same result both ways): 

Please Login or Register  to view this content.
What is happening is, when I open Timecard, the macro runs, and text.xlsx opens. BUT, it prompts me for a password. It was prompting me twice, but I added the UpdateLinks argument and now it's just asking once.

Here's something else: If I open Timecard and then open VBA, click in the code and F5 to run it, it opens the test file just fine, without prompting me. It only prompts me when the code runs "automatically" either via the open workbook method or the Sub Auto_Open.

This test document just has one linked workbook, but the real one has 16+, so entering 16+ passwords is really getting hard on my client. Anyone have any ideas?

Thanks!

Karin