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

  • Thread starter Thread starter TONY
  • Start date Start date
T

TONY

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InputBox to name a range 2
changing button prop with vba 9
Need text from embedded Word object 2
Why is Excel 2003 changing the names of my macros?? 1
Change multiple object group name 7
Problem renaming command buttons with code 2
Toggling a Command Button 2
Application Crash Whie adding Code lines using VBA 4

Back
Top