在VBE中看不到excel表 [英] Cannot see excel sheet in VBE

问题描述

我正在使用由其他人创建的Excel文件。
包含宏的一张表单似乎受到密码保护，但我不明白的是，我在VBE中不能在表格列表下看到它。表单选项卡在Excel中可见，但我看不到内容。

有没有办法在VBE中取消隐藏？

解决方案

包含宏的一张表

引用Excel 4.0宏？

包含Excel 4.0宏的工作表在VBE的列表中似乎不可见。

它们似乎在某种程度上可以从VBA访问：使用Excel 2007我将Excel 4.0宏表单插入到工作簿中，然后尝试以下操作：

  Public Sub TestAccessToXL4MacroSheet（）
 Dim ws As Worksheet 
设置ws = ThisWorkbook.ActiveSheet'成功
 Debug.Print ws.Name'输出Macro1
设置ws =工作表（Macro1）'失败：下标超出范围
 End Sub 
  

I am working with an Excel file that was created by somebody else. One sheet containing Macros appears to be password protected, but what I don't understand is that I cannot see it in VBE under the sheet list. The sheet tab is visible in Excel, but I cannot see the content.

Is there any way to unhide it in VBE?

解决方案

One sheet containing Macros

Does that refer to Excel 4.0 macros?

Worksheets containing Excel 4.0 macros don't appear to be visible within the list in VBE.

They do appear to be accessible from VBA to some extent: using Excel 2007 I inserted an Excel 4.0 macro sheet to a workbook then tried the following:

Public Sub TestAccessToXL4MacroSheet()
Dim ws As Worksheet
    Set ws = ThisWorkbook.ActiveSheet ' succeeds
    Debug.Print ws.Name               ' outputs "Macro1"
    Set ws = Worksheets("Macro1")     ' fails: "Subscript out of range"
End Sub

这篇关于在VBE中看不到excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！