View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 276
Default Command Button coding

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.Comma ndButton.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....