View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karoo News[_2_] Karoo News[_2_] is offline
external usenet poster
 
Posts: 17
Default Follow on from Hiding 5 command buttons - Excel 97 prob now

Hi I got this from Tom which works great on my Office XP but does not work
on 97. I'm not really familiar with that! Is it that 97 does not recognise
these instructions? Help most respected!

Sub ABC()
Dim Obj As OLEObject
For Each Obj In Worksheets( _
"New Style 2006").OLEObjects
If TypeOf Obj.Object Is MSForms.CommandButton Then
Obj.Visible = Not Obj.Visible
End If
Next
End Sub