Hi,
In my system I am not able to assign macro to command button by right
clicking it and simply selecting the "Assign Macro", the assign macro option
is not showing once I right click. But any file I receice from outside has
that option once i right click.

Do i need to change any of the setting in my excel workbook, Thanks for help
in advance.

Hi

Is your sheet protected? If so Unprotect first, assign the macro then
Protect.


--
Regards
Roger Govier

"SANDIND" <(E-Mail Removed)> wrote in message
news:353B92D0-30C3-4ED8-A305-(E-Mail Removed)...
> Hi,
> In my system I am not able to assign macro to command button by right
> clicking it and simply selecting the "Assign Macro", the assign macro
> option
> is not showing once I right click. But any file I receice from outside has
> that option once i right click.
>
> Do i need to change any of the setting in my excel workbook, Thanks for
> help
> in advance.

Maybe the OP have a controltoolbox button instead of a Forms button on the worksheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message news:BFED2D79-832A-41D7-A1AE-(E-Mail Removed)...
> Hi
>
> Is your sheet protected? If so Unprotect first, assign the macro then
> Protect.
>
>
> --
> Regards
> Roger Govier
>
> "SANDIND" <(E-Mail Removed)> wrote in message
> news:353B92D0-30C3-4ED8-A305-(E-Mail Removed)...
>> Hi,
>> In my system I am not able to assign macro to command button by right
>> clicking it and simply selecting the "Assign Macro", the assign macro
>> option
>> is not showing once I right click. But any file I receice from outside has
>> that option once i right click.
>>
>> Do i need to change any of the setting in my excel workbook, Thanks for
>> help
>> in advance.
>

Thanks Ron, You are Genius . I inserted Form and inserted button, then I am
able to assign the Macro.

Thanks to both of you for the support.


"Ron de Bruin" wrote:

> Maybe the OP have a controltoolbox button instead of a Forms button on the worksheet
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message news:BFED2D79-832A-41D7-A1AE-(E-Mail Removed)...
> > Hi
> >
> > Is your sheet protected? If so Unprotect first, assign the macro then
> > Protect.
> >
> >
> > --
> > Regards
> > Roger Govier
> >
> > "SANDIND" <(E-Mail Removed)> wrote in message
> > news:353B92D0-30C3-4ED8-A305-(E-Mail Removed)...
> >> Hi,
> >> In my system I am not able to assign macro to command button by right
> >> clicking it and simply selecting the "Assign Macro", the assign macro
> >> option
> >> is not showing once I right click. But any file I receice from outside has
> >> that option once i right click.
> >>
> >> Do i need to change any of the setting in my excel workbook, Thanks for
> >> help
> >> in advance.
> >
>