View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default 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