Changing Control Object Name( command buttons etc ) from VBA code
 

When I use the following code the object name gets changed, but generates an
error message.

Sub testit()
ActiveSheet.OLEObjects("CommandButton1").Name = "newname"
End Sub

ERROR MESSAGE:

MICROSOFT VISUAL BASIC
" Can't enter break mode at this time"

Any

Changing Control Object Name( command buttons etc ) from VBA code
 

ActiveSheet.CommandButton1.Name = "newname"

--

Regards,
Nigel




"TONY" wrote in message
...
When I use the following code the object name gets changed, but generates
an
error message.

Sub testit()
ActiveSheet.OLEObjects("CommandButton1").Name = "newname"
End Sub

ERROR MESSAGE:

MICROSOFT VISUAL BASIC
" Can't enter break mode at this time"

Any