I am a novice Excel v97 programmer who is dabbling in
Visual Basic. I have somehow changed a setting so that now
each time I pull up the forms box and try to add a Control
Button to my worksheet (which easily facilitates simple
macros), I get an embedded "CommandButton" instead.

Can anyone tell me how to change this back so I will get a
Control Button from the forms box instead of a Command
Button?

Appreciate your help

Are you sure you're using the Forms toolbar. (It sounds like you grabbed the
commandbutton icon from the controltoolbox toolbar.)

But if you think you screwed up (er, made minor modifications to) the Forms
toolbar, maybe you could just reset it.

tools|Customize|Toolbars tab
select Forms
click Reset

(I've backed up my *.xlb file (where these customizations are kept) so that I
can screw up (er, make minor modifications to) any toolbar. If I screw it up
too much, I'll just copy the *.xlb back to the correct spot.

You can use Windows|find to search for *.xlb (look in hidden folders for hidden
files) to find the file to backup.

RGibson wrote:

I am a novice Excel v97 programmer who is dabbling in
Visual Basic. I have somehow changed a setting so that now
each time I pull up the forms box and try to add a Control
Button to my worksheet (which easily facilitates simple
macros), I get an embedded "CommandButton" instead.

Can anyone tell me how to change this back so I will get a
Control Button from the forms box instead of a Command
Button?

Appreciate your help

--

Dave Peterson