I can't find the Assign Macro command Dave 27.09.2006 17:48:01 I am trying to assign a Macro that I recorded to a command button. However when I right click on the sizing bar of the command button "Assign Macro" does not appear. Is thare another way to do this?

Re: I can't find the Assign Macro command Dave Peterson <petersod[ at ]verizonXSPAM.net> 27.09.2006 17:56:59 You used a commandbutton from the Control toolbox toolbar. Delete that one and add a button from the Forms toolbar. Dave wrote: [Quoted Text] > > I am trying to assign a Macro that I recorded to a command button. However > when I right click on the sizing bar of the command button "Assign Macro" > does not appear. Is thare another way to do this? -- Dave Peterson

Re: I can't find the Assign Macro command "PCLIVE" <pclive(RemoveThis)[ at ]cox.net> 27.09.2006 18:01:52 I'm not sure if there is anything against doing this (as I've been doing it this way for some time), but you can go to 'View Code' and then just type the name of your macro. That should run your macro when the button is clicked. HTH, Paul "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message news:451ABB6B.B1EEE4EB[ at ]verizonXSPAM.net... [Quoted Text] > You used a commandbutton from the Control toolbox toolbar. > > Delete that one and add a button from the Forms toolbar. > > Dave wrote: >> >> I am trying to assign a Macro that I recorded to a command button. >> However >> when I right click on the sizing bar of the command button "Assign Macro" >> does not appear. Is thare another way to do this? > > -- > > Dave Peterson

Re: I can't find the Assign Macro command Dave Peterson <petersod[ at ]verizonXSPAM.net> 27.09.2006 18:08:02 Personally, I like the buttons/controls from the Forms toolbar for most things. I find that they're "lighter" than their counterparts from the control toolbox toolbar. PCLIVE wrote: [Quoted Text] > > I'm not sure if there is anything against doing this (as I've been doing it > this way for some time), but you can go to 'View Code' and then just type > the name of your macro. That should run your macro when the button is > clicked. > > HTH, > Paul > > "Dave Peterson" <petersod[ at ]verizonXSPAM.net> wrote in message > news:451ABB6B.B1EEE4EB[ at ]verizonXSPAM.net... > > You used a commandbutton from the Control toolbox toolbar. > > > > Delete that one and add a button from the Forms toolbar. > > > > Dave wrote: > >> > >> I am trying to assign a Macro that I recorded to a command button. > >> However > >> when I right click on the sizing bar of the command button "Assign Macro" > >> does not appear. Is thare another way to do this? > > > > -- > > > > Dave Peterson -- Dave Peterson