Linking to password protected worksheets.

[Slapdad]

I have 50+ budgets that are all on a server and each has it's own, unique password to keep prying eyes for seeing sensitive payroll information. Several of those locations have positions whose bonus is a function of a sales number for an area or region, which is a roll-up of several budget files. Is there any way to enable certain files to roll-up numbers from a number of password protected files without typing in the password for each file?

 

[dtaylor]

you will need to access the files via vba and unprotect then protect the files inline once your operation is done.

lookup information on protecting and uprotecting spreadsheets.

here is a sample that i use:

Sub ProtectTabbies()
Dim mySheet As Worksheet
For Each mySheet In Worksheets
mySheet.Protect "SIMONE", True, True
Next mySheet
End Sub

'Unprotect whole worksheet
Sub UnProtectTabbies()
Dim mySheet As Worksheet
For Each mySheet In Worksheets
mySheet.Unprotect "SIMONE"
Next mySheet
End Sub