View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to install 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.