Command Button Assignment

[Bill Martin]

Some bit of configuration evidently changed in my Excel97 that I'm having
difficulty tracking down. Up to now I've had it set up so that the control
toolbox is displayed all the time in the tool bar. And when I'd click on the
"Command Button" icon I could create a button on my spreadsheet and then Excel
would ask me to assign a macro to it. All was well.

Somehow the control toolbox disappeared from my toolbar today. Grumble,
grumble... So I go into View>Toolbars>ControlToolbox and reselect it. The
toolbox pops up in it's own little window that I've never seen before. Hmmm...
So I drag the window to the toolbar and it seems to attach there looking about
the same as it always had. Now however when I click to create a "command
button" it creates the button assigned to a dummy Private Sub that it also
created for me on the worksheet. I can't find any way to assign it to an
arbitrary Sub I've written in a module somewhere as I used to. There is no
"assign macro" entry on the drop down menu that comes when I right click on the
button now. It seems to be permanently assigned to the dummy Sub it created.

Any idea how to get it back into the original mode so I can assign any macro I
want to it and don't have code stored on each worksheet that I put a button on?

Thanks...

Bill

 

[Jim Rech]

And when I'd click on the "Command Button" icon I could create a button onwould ask me to assign a macro to it.

This behavior is what you get with the Forms toolbar button. I suspect
you've been using that.

 

[Bill Martin]

This behavior is what you get with the Forms toolbar button. I suspect
you've been using that.

----------------------------------

You're 100% correct! Thanks for the help. I never realized one could create a
button from "forms" or from "controls" and get two slightly different behaviors
from it.

Thanks...

Bill