• 0

Solved Linking Password Protected Workbooks

  • 0

I’ve seen it said that you cannot linked password protected workbooks but I’m hoping the person that posted that, just didn’t know how to do it.

I have three workbooks used by different teams in the same department. The ‘Master’ workbook pulls back data a2 through r400 from WB ‘Raw Data’ and s2 through w400 from WB ‘Review.’

All three of these workbooks are used by different teams (Quality for Master, Accounts for Raw Data, Review for Review) which is why they’re password protected.

Is there anyway to NOT have to put in the password for the fields on Master to automatically update?


1 Answer

  1. If viewing the data is OK, why are the workbooks protected?

    Use protection at the worksheet level to prevent changes and you shouldn’t have any problems linking to them.

    If you must protect them at the workbook level, then you’ll need to open all workbooks with code that resides in the workbook that is trying to pull data from them.

    Sub Open_Protected_File()
      Workbooks.Open Filename:= _
         "\\MyPath\Users\UserName\My Documents\MyFile.xlsm", Password:="Secret"
      Workbooks.Open Filename:= _
         "\\MyPath\Users\UserName\My Documents\MyOtherFile.xlsm", Password:="Secret"
    End Sub

    Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

    • 0