Excel不会显示工作簿工作表 [英] Excel won't show the workbooks worksheets

问题描述

我有一个包含三个工作表的Excel工作簿。然而，所有的表格似乎都被隐藏，他们的可见性设置为xlSheetVisible（通过查看VBA编辑器中的工作表属性找到）。

这是我试过的目前为止解决问题。

• 搜索Google寻求帮助，但所有类似的问题已经通过从xlSheetHidden更改可见性来解决到xlSheetVisible。但是在我的情况下，该设置已经设置为xlVisible。

  
  
  
  
  
  • 通过使用VBA，我尝试激活一个没有任何结果的工作表。 li>
    

通过阅读这个，你可能已经猜到我可以看到并访问工作表来自VBA编辑器。

尽管正在查看正常的Excel用户界面，但所有按钮都被禁用，并且点击toftft角落的办公室/文件按钮不允许我保存工作簿。但是，如果我对VBA本身进行任何更改并尝试关闭工作簿，那么Excel会询问我是否要保存工作簿。

解决方案

你所描述的一切让我相信你隐藏了工作簿窗口，而不是工作表。当隐藏工作簿窗口时，所有工作表都将被隐藏，并且工具栏中的大部分功能将被灰显。

在Visual Basic编辑器中，您还可以看到所有的工作表，其可见性将为 xlVisible ，但它们在屏幕上看不到。这是因为它们是可见的，但是显示它们的窗口不是。

请尝试点击工具栏中的查看选项卡，然后在窗口窗格下，点击取消隐藏。

如果这不起作用，请尝试切换工作簿的可见性。 >

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.

• 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.

  • By using VBA I have tried to activate a sheet without any result.

By reading this you might have guessed that I am able to see and access the worksheets from the VBA editor.

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.

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屋！