Re: Cant assign macro to command button

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 21:44:09 -0000

You're welcome :-) 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
              Sys Spec - Win XP Pro /  XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"GFM" <gfm@hotmail.com> wrote in message 
news:uzrrVRzwEHA.1264@TK2MSFTNGP12.phx.gbl...
> damm! you're right
> fantastic. so it's not the command button in toolbox that i should choose
> simply use it from the 'forms' toolbar
> cheers 4 yr help
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:%23P$NosbwEHA.2568@TK2MSFTNGP11.phx.gbl...
>> That or change your button for one from the FORMS toolbar.
>>
>> -- 
>> Regards
>>            Ken.......................    Microsoft MVP - Excel
>>               Sys Spec - Win XP Pro /  XL 97/00/02/03
>>
>> --------------------------------------------------------------------------
> --
>> It's easier to beg forgiveness than ask permission :-)
>> --------------------------------------------------------------------------
> --
>>
>>
>>
>> "papou" <pasbonpapou@canonplus44.fr> wrote in message
>> news:e9nmPQawEHA.2540@TK2MSFTNGP09.phx.gbl...
>> > Hi
>> > It seems like you have created a command button from the controls Tools
> box.
>> > In which case the option you're after is "View Code"
>> > HTH
>> > Cordially
>> > Pascal
>> >
>> > "GFM" <gfm@hotmail.com> a écrit dans le message de
>> > news:eqTXKEZwEHA.3808@TK2MSFTNGP15.phx.gbl...
>> >> Hello people
>> >>
>> >> Wonder if u can help me, it shld b a really str8fwd pb
>> >>
>> >> I've created a simple macro (for inserting columns & copying across
> data),
>> >> and wanted to assign it to a command button.
>> >> Usually, I'd right-click that button, choose 'assign macro' and select
> my
>> >> macro...
>> >>
>> >> Only thing is, there's not that option.
>> >>
>> >> So, is it a case of selecting or switching an option on/off in the
> tools>
>> >> options menu?
>> >> I did try the Tools> Macros> Security, to enable Medium security, but
> it
>> >> didnt help.
>> >>
>> >> I'm using Win2k Pro, and Excel 2k Sp3
>> >>
>> >> Cheers!
>> >>
>> >> Gui.
>> >>
>> >>
>> >
>> >
>>
>>
>> ---
>> Outgoing mail is certified Virus Free.
>> Checked by AVG anti-virus system (http://www.grisoft.com).
>> Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
>>
>>
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004