Excel不会显示工作簿工作表-Excelwon'tshowtheworkbooksworksheets

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

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

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.

  搜索了谷歌寻求帮助，但通过将可见性从xlSheetHidden更改为xlSheetVisible，解决了所有类似的问题。但在我的情况下，设置已设置为xlVisible。

  • By using VBA I have tried to activate a sheet without any result.
  • 通过使用VBA，我试图激活一张没有任何结果的工作表。

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

通过阅读本文，您可能已经猜到我能够从VBA编辑器中查看和访问工作表。

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.

尽管查看了普通的Excel用户界面，但所有按钮都被禁用，并且单击topleft角落中的office / file按钮不允许我保存工作簿。但是，如果我对VBA本身进行任何更改并尝试关闭工作簿，则Excel会询问是否要保存工作簿。

2 个解决方案