在Excel 2007中隐藏工作表（使用密码）或在Excel中隐藏VBA代码 [英] Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel
问题描述
我发现了一种隐藏Excel表格的方式，如下所示：在VBAProject属性中将表格的可见性设置为VeryHidden，然后密码保护VBAProject属性。
I found a way to hide Excel sheets which is as follows: set the visibility of the sheet to VeryHidden in the VBAProject properties and then password protect VBAProject properties.
这很棒，但是在Excel 2007中，如果将其保存为XLSX，则会剥离VBAProject密码保护，您可以查看VBA代码。有没有办法阻止这种情况？
This is great, but in Excel 2007, if you save it as XLSX, the VBAProject password protection is stripped and you can view the VBA code. Is there any way to prevent this?
或者，是否有其他方式隐藏Excel 2007表？
OR, is there any other way to hide an Excel 2007 sheet?
推荐答案
这是你在Excel 2003中所做的工作：
Here is what you do in Excel 2003:
- 格式 - >表单 - >隐藏并隐藏您的工作表。
- 转到工具 - >保护 - >保护工作簿选择结构，然后输入您选择的密码。
- In your sheet of interest, go to Format->Sheet->Hide and hide your sheet.
- Go to Tools->Protection->Protect Workbook, make sure Structure is selected, and enter your password of choice.
一旦完成，隐藏，如果没有密码就不能被隐藏。合理？
Once this is done, the sheet is hidden and cannot be unhidden without the password. Make sense?
（给定Excel的向后兼容性，我相信你可以在2007年这样做）
(Given Excel's backward compatibility, I'm sure you can do this in 2007)
如果您真的需要保留一些计算机密码，请尝试：使用Access（或其他Excel工作簿或您选择的其他数据库）来计算您需要计算的内容，并导出只有您的Excel工作簿中的未分类结果。
If you really need to keep some calculations secret, try this: use Access (or another Excel workbook or some other DB of your choice) to calculate what you need calculated, and export only the "unclassified" results to your Excel workbook.
这篇关于在Excel 2007中隐藏工作表（使用密码）或在Excel中隐藏VBA代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
