Hi,

I have a macro setup to create a new worksheet when a button is clicked. In that macro it creates a CommandButton on the new sheet. The code works fine to rename the button itself, but not to change the caption of the button. Also, I know the last two lines should do the same thing, but neither of them is working. =( Can anyone help?

Set vObj = ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Left:=596.25, Top:=111, _
 Width:=72, Height:=24)
vObj.Name = "MiscInfo"
vObj.Caption = "Misc Info"
MiscInfo.Caption = "Misc Info"