Excel不会显示工作簿工作表 [英] Excel won't show the workbooks worksheets
问题描述
我有一个包含三个工作表的Excel工作簿.但是，尽管所有工作表的可见性都设置为xlSheetVisible(通过在VBA编辑器中查看工作表属性来发现)，但似乎都隐藏了.
I have an Excel Workbook containing three worksheets. However all sheets seem to be hidden dispite that their visibility is set to xlSheetVisible (Found by looking at the worksheet properties in the VBA editor).
这是我到目前为止为解决该问题所做的尝试.
This is what I have tried so far to solve the problem.
-
搜索了Google的帮助，但通过将可见性"从xlSheetHidden更改为xlSheetVisible，已解决了所有类似问题.但就我而言，该设置已经设置为xlVisible.
Searched Google for help, but all similar problems have been solved by changing the Visibility from xlSheetHidden to xlSheetVisible. But in my case that setting is already set to xlVisible.
- 通过使用VBA，我试图激活工作表而没有任何结果.
通过阅读本文，您可能已经猜到我能够从VBA编辑器中查看和访问工作表.
By reading this you might have guessed that I am able to see and access the worksheets from the VBA editor.
尽管查看普通的Excel用户界面，所有按钮都被禁用，并且单击左上角的office/file按钮不允许我保存工作簿.但是，如果我对VBA本身进行了任何更改并尝试关闭工作簿，则Excel会询问我是否要保存工作簿.
Despite that looking at the normal Excel userinterface, all buttons are disabled and clicking at the office/file button in the topleft corner doesn't allow me to save the workbook. However if I make any changes to the VBA itself and tries to close the workbook then Excel asks whether or not I would like to save the workbook.
推荐答案
您描述的所有内容都使我相信您是在隐藏工作簿窗口，而不是工作表.隐藏工作簿窗口时，所有工作表都将隐藏，并且工具栏中的许多功能都将显示为灰色.
Everything you describe leads me to believe you're hiding the workbook window, not the worksheets. When a workbook window is hidden, all the sheets become hidden and much of the functionality from the toolbar greys out.
在Visual Basic编辑器中，您还可以看到所有工作表，其可见性为 xlVisible ，但无法在屏幕上看到它们.这是因为它们是可见的，但是显示它们的窗口却不可见.
In the Visual Basic Editor, you'd also be able to see all of the worksheets and their visibility would be xlVisible, yet they cannot be seen on the screen. This is because they ARE visible, but the window which displays them is not.
请尝试单击工具栏中的查看标签，然后在窗口窗格下，单击取消隐藏.
Please try clicking the View tab in the toolbar, and then under the Window pane, click Unhide.
如果这不起作用，请尝试切换工作簿的可见性.
If this doesn't work, then try toggling visibility of the workbook.
这篇关于Excel不会显示工作簿工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
