Thanks Leith,

It is a Toolbox Command Button, I think. How do I tell the difference to be sure? And by:

Quote Originally Posted by Leith Ross
Change the command buttons in the examples to their original code names. This is not the same as the caption. This is the name the system used when they were created.
do you mean that I should change it's name from cmdStartWiard back to CommandButton1? I ask because I thought that once a name (as in its (Name) from the properties) was changed you could reference that in code without issue. Is this not always the case?

Quote Originally Posted by Leith Ross
Hello Amber_D_Laws,

You can't reference a command button on worksheet the same way you reference it on a UserForm. There are 2 types of command buttons and you don't which you are using, so i will include the referencing methods for both.

Forms Toolbar Command Button Example:

With ActiveSheet.Shapes("Button 1")
.TextFrame.Characters.Text = "Quote Wizard Disabled" & vbLf & "please use editing button"
.ControlFormat.Enabled = False
End With


Control Toolbox Command Button Example:

Dim cmdButton As Object
Set cmdButton = ActiveSheet.OLEObjects("CommandButton1").Object
cmdButton.Caption = "Quote Wizard Disabled" & vbLf & "please use editing button"
cmdButton.Enabled = False


Change the command buttons in the examples to their original code names. This is not the same as the caption. This is the name the system used when they were created.

Sincerely,
Leith Ross