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.