software

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
quot;Command Buttonquot; 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 Viewgt;Toolbarsgt;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 quot;command
buttonquot; 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
quot;assign macroquot; 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

gt;gt;And when I'd click on the quot;Command Buttonquot; icon I could create a button on
gt;gt;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
quot;Bill Martinquot; gt; wrote in message
...
gt; Some bit of configuration evidently changed in my Excel97 that I'm having
gt; difficulty tracking down. Up to now I've had it set up so that the
gt; control
gt; toolbox is displayed all the time in the tool bar. And when I'd click on
gt; the
gt; quot;Command Buttonquot; icon I could create a button on my spreadsheet and then
gt; Excel
gt; would ask me to assign a macro to it. All was well.
gt;
gt; Somehow the control toolbox disappeared from my toolbar today. Grumble,
gt; grumble... So I go into Viewgt;Toolbarsgt;ControlToolbox and reselect it.
gt; The
gt; toolbox pops up in it's own little window that I've never seen before.
gt; Hmmm...
gt; So I drag the window to the toolbar and it seems to attach there looking
gt; about
gt; the same as it always had. Now however when I click to create a quot;command
gt; buttonquot; it creates the button assigned to a dummy Private Sub that it also
gt; created for me on the worksheet. I can't find any way to assign it to an
gt; arbitrary Sub I've written in a module somewhere as I used to. There is
gt; no
gt; quot;assign macroquot; entry on the drop down menu that comes when I right click
gt; on the
gt; button now. It seems to be permanently assigned to the dummy Sub it
gt; created.
gt;
gt; Any idea how to get it back into the original mode so I can assign any
gt; macro I
gt; want to it and don't have code stored on each worksheet that I put a
gt; button on?
gt;
gt; Thanks...
gt;
gt; Bill
Jim Rech wrote:
gt;gt;gt;And when I'd click on the quot;Command Buttonquot; icon I could create a button on
gt;gt;gt;my spreadsheet and then Excel would ask me to assign a macro to it.
gt;
gt; This behavior is what you get with the Forms toolbar button. I suspect
gt; you've been using that.
gt;
----------------------------------

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

Thanks...

Bill