Hi

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


--
Regards
Roger Govier

"SANDIND" wrote in message
...
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.