Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-28-2016, 04:57 PM
patidallas22 patidallas22 is offline Windows XP Office 2007
Novice
 
Join Date: Mar 2012
Posts: 12
patidallas22 is on a distinguished road
Default Password Encrypted workbooks linking together

I have a complicated scenario I need solved:

We have several workbooks (Workbook A, B, C, D) where each user will have their own unique encrypted password. Then we have a master workbook (Master) with it's own encrypted password that has formulas that link back to the password protected workbooks.



- We want to be able to create a macro so that the person opening the Master after clicking "update links" won't have to enter all the different passwords for each of the workbooks (A, B, C, D) and so that the formulas will automatically update without having to open the workbooks A, B, C, D.

To add to the complication, they want Workbooks A, B, C, D to have a formula which will also link back to one column from the Master but without being able to open the Master since it contains sensitive data. We are thinking an auto macro of some sort so they can't see or know the Master Password. These guys barely can get around in Excel so they won't know how to go looking for a password under programming, but we just want it to be automated so that when they open their Workbook A or Workbook B, it auto updates from the Master.

Likewise, the Master user can know all the passwords, but since there are literally 16 workbooks linking together, we want a macro so she won't have to enter all those passwords.

Thanks for the help!
Reply With Quote
Reply

Tags
macros, passwords, workbooks
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2008 workbooks into Office 2011 workbooks nfotx Excel 0 12-07-2014 04:22 PM
Linking Workbooks/Entire Worksheets to Identical in Master taxacct Excel 2 10-01-2014 11:22 AM
Encrypted macros wont run... hanvyj Excel 1 02-25-2014 06:18 AM
E-Mails Encrypted wildwilly5891 Outlook 1 10-22-2011 06:16 PM
encrypted and password protected in 2000 and 2007 Soudabeh Word 0 12-14-2010 06:35 AM


All times are GMT -7. The time now is 06:39 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft