I have macro which i want to install on other computers så users can
activate macro if they choose in the menu functions,macro.

You should put it in an addin and the addin should create the menu item


Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/ba...n_addins97.htm
http://msdn.microsoft.com/library/of...exceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications


--
Regards,
Tom Ogilvy

"Alen32" wrote in message
lkaboutsoftware.com...
I have macro which i want to install on other computers så users can
activate macro if they choose in the menu functions,macro.

thanks a lot!!