I need to hide the labels on a sheet if a certain cell has a specific value. The labels are not activeX labels, but are the form control labels. I know how to loop through activeX controls. See code below. But how do I code this for the form control label?
![]()
For Each OleObj In ActiveSheet.OLEObjects If OleObj.progID = "Forms.Label.1" Then OleObj.Object.Visible = False End If Next OleObj
Bookmarks