Command Button Assignment
 

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 ViewToolbarsControlToolbox 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

Command Button Assignment
 

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.

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

--
Jim
"Bill Martin" wrote in message
...
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 ViewToolbarsControlToolbox 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

Command Button Assignment
 

Jim Rech wrote:
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.

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