有没有办法我可以打开主工作簿而无需输入每个密码？ [英] Is there any way that I can open the master workbook without having to enter each password?

问题描述

我有许多已加密的工作簿，因此有密码。这些工作簿链接到主文档，旨在监视对每个工作簿所做的更改。这非常正常，但是当我打开主工作簿时，系统会提示我输入每个其他工作簿的密码！显然这有点烦人！



有没有办法打开主工作簿而无需输入每个密码？

I have a number of workbooks that have been encrytped and therefore have passwords. These workbooks are linked to a master document designed to monitor changes made to each workbook. This works absolutely fine, but when I open the master workbook I am prompted to enter the passwords for each of the other workbooks! Obviously this is a tad annoying!

Is there any way that I can open the master workbook without having to enter each password?

推荐答案

正如Richard MacCutchan在问题评论中提到的那样，使用VBA，如下所示：链接到受密码保护的工作簿 [ ^ ]



我建议你从源工作簿中删除保护。最好将它们移动到单个文件夹并管理该级别的用户权限。它更容易，更容易混淆。

As Richard MacCutchan has mentioned in the comment to the question, use VBA as is shown here: Linking to a password protected workbook[^]

I would suggest you to remove protection from source workbooks. Better move them to single folder and manage the users rights from that level. It's much easier and less confusing.

这篇关于有没有办法我可以打开主工作簿而无需输入每个密码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！