Sub Test() Dim Cnt AsByte Dim i AsByte Cnt = Application.CommandBars(3).Controls.Count For i = 1 To Cnt Application.CommandBars(3).Controls(i).Enabled = 1 Next i EndSub
Sub Test() Dim Cnt AsByte Dim i AsByte Cnt = Application.CommandBars(3).Controls.Count For i = 1 To Cnt Application.CommandBars(3).Controls(i).Enabled = 1 Next i EndSub