请提供一个Excel表中28到34行检测到单元格B22显示的条件为老重力合页和精铸合页时进行隐藏
时间: 2024-02-12 16:07:36 浏览: 30
以下是一个简单的VBA代码,它将检查单元格B22的值,如果值为“老重力合页”或“精铸合页”,则隐藏28到34行:
```
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$22" Then
If Target.Value = "老重力合页" Or Target.Value = "精铸合页" Then
Rows("28:34").EntireRow.Hidden = True
Else
Rows("28:34").EntireRow.Hidden = False
End If
End If
End Sub
```
请将此代码复制并粘贴到工作表的代码窗口中。要打开代码窗口,请在Excel中按下Alt + F11。在左侧的项目浏览器中,选择要添加代码的工作表,然后选择“插入”>“模块”添加一个新模块。将代码复制粘贴到新模块中,保存并关闭代码窗口。
相关问题
外部检测服务供应方要求具备从事相关检测能力的资质证明,包括资质证书和能力范围,按3017测试-030《安吉精铸公司外委检测供方评审表》执行。翻译成英文
External testing service providers are required to possess qualifications and credentials demonstrating their capabilities in performing relevant testing, including qualification certificates and scope of capabilities in accordance with the ANJI Precision Casting Company's outsourced testing provider evaluation form (3017 testing-030).
技术负责人根据3017测试-061《安吉精铸公司外委检测供方评审表》,将拟分包的项目和分包实验室报测试中心主任批准后签发《检测分包协议书》。翻译成英文
The technical leader shall submit the proposed subcontracted project and subcontracted laboratory to the director of the testing center for approval based on the Evaluation Form for External Testing Suppliers of Anji Precision Casting Company (Test-061, 3017), and issue the Subcontracting Agreement after approval.