C
Corey
In my quest for the ultimate project goal, i am now trying to place a comman
button on a new sheet.
I can get the code below to place it on the sheet, but when i recorded the
code in did not record the Button Title, nor the sheets("Leave
Blank").select step.
Is there a way i can code this into the below code to create the button?
ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
, DisplayAsIcon:=False, Left:=264.75, Top:=516.75, Width:=119.25, _
Height:=22.5).Select
Want the button to be Captioned "EXIT"
and
the clicking of it to selecting sheet named "Leave Blank".
Corey....
button on a new sheet.
I can get the code below to place it on the sheet, but when i recorded the
code in did not record the Button Title, nor the sheets("Leave
Blank").select step.
Is there a way i can code this into the below code to create the button?
ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
, DisplayAsIcon:=False, Left:=264.75, Top:=516.75, Width:=119.25, _
Height:=22.5).Select
Want the button to be Captioned "EXIT"
and
the clicking of it to selecting sheet named "Leave Blank".
Corey....