This portion?

For i = LBound(mac_names) To UBound(mac_names)
With .Controls.Add(Type:=msoControlButton)
.OnAction = myName & "!" & mac_names(i)

I think it's ok as-is.



mike wrote:

On the "myName = " line, is that just a message post typo or is your
code missing a right parenthesis at the end?

mike

--

Dave Peterson