Thread
:
Changing Control Object Name( command buttons etc ) from VBA code
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
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
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]