Updating Workbook from Password Protected Workbooks automatically

**kmt1609** · 07-07-2014, 05:53 AM

Hi

Hopefully a simple question

I've 10 workbooks (which represent different areas around the factory) that populate a master workbook (belonging to HR).

We've now started to password protect the 10 workbooks. When i open the master workbook and click update - i get prompted to enter the passwords of the 10 workbooks

My question - is it possbile to automatically have the passwords entered so that the master can get updated?

Hope that makes sense !!!

**TMS** · 07-07-2014, 05:58 AM

Not without VBA. You could have a workbook open event that opens all the slave workbooks using their (stored) passwords. But then the Master workbook would have to be macro enabled and the HR staff would need to enable the macros when they opened it.

Regards, TMS

Updating Workbook from Password Protected Workbooks automatically

LinkBack

Thread Tools

Rate This Thread

Display

Updating Workbook from Password Protected Workbooks automatically

Re: Updating Workbook from Password Protected Workbooks automatically

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Password array to open all password protected workbook in a folder

Automatically updating a workbook with information from several workbooks

Updating Links from Password protected Workbooks

Linking to password-protected workbooks

Password protected workbooks

Bookmarks

Bookmarks

Posting Permissions