Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Menu
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Menu
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) SJC wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming |