Thread: New Menu
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default New Menu

Put them in an addin.


http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

http://support.microsoft.com/default.aspx?kbid=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/default.aspx?kbid=179008
MacXL: How to Create an Add-in File in Microsoft Excel


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SJC" wrote in message
...
Does anyone know how I can create a custom menu that is present in all
workbooks once installed? Basically I've created some custom
functions/macros that I want to distribute to a small user base and have
them be able to run them from whatever workbook they're using. I don't

want
to have to teach them to run macros. I can create the custome menu but

only
for the original workbook, I want to add it as a feature in excel. Can I

do
this through an add in? Thanks in advance