根据单元格值取消隐藏工作表 [英] Unhide sheets according to cell value
问题描述
我有一份报告,分为6个访问不同的部分,我希望能够
取消隐藏 根据安全优先级,一组 表 。
即 表示单元格内容"General"对于单元格内容"Level1",它将
取消隐藏 Sheet1,Sheet2和Sheet3然后Sheet4到Sheet6,将是工作表
unhiden ...
I have a report which is divided in 6 access distinct sections, I would like to be able to unhide a group of sheets according to a security priority. i.e. for cell contents "General" it would unhide Sheet1, Sheet2 and Sheet3, for cell contents "Level1" then Sheet4 to Sheet6, would be the sheets unhiden...
只是一个小笔记:
VB代码将受密码保护
The VB code will be protected with a password
有什么方法可以做到吗?
Is there any way that could be done?
谢谢你帮助,
推荐答案
据我所知,你有工作簿和受保护的工作表,而你想要导航到工作表...
As far I understand, you have workbook with protected sheets, and you want to make navigate to sheets...
如果你已经锁定了VBA,那么你应该使用 单独添加。
If you have VBA locked then you should use separate addin.
看看这个: Move
工作表之间的活动工作簿加载项
Take look on this: Move between worksheets active workbook Add-in
这篇关于根据单元格值取消隐藏工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!