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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=507754