New Menu

[SJC]

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

 

[Bob Phillips]

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)

 

[Dave Peterson]

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)