Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The right Menu
Hi guys, I have done a little research and I have found a few threads but they are well out of my league. I need to create a menu to the menu bar in 2003. _Price_List_ _G_et Data P_r_e Printed _P_rint ------------------- _S_ave I would be greatful is someone could give me a hand and explain the code. Regards Bach -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401641 |
#2
|
|||
|
|||
How are you creating it? If just customizing a toolbar manually, then
"Pri&ce List" (without the quotes) will make the menu option activate on Alt+C. Otherwise, I don't understand what all your underlines are supposed to mean. ************ Anne Troy www.OfficeArticles.com "bach" wrote in message ... Hi guys, I have done a little research and I have found a few threads but they are well out of my league. I need to create a menu to the menu bar in 2003. _Price_List_ _G_et Data P_r_e Printed _P_rint ------------------- _S_ave I would be greatful is someone could give me a hand and explain the code. Regards Bach -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401641 |
#3
|
|||
|
|||
For menu creation, take a look at John Walkenbach's MenuMaker:
http://j-walk.com/ss/excel/tips/tip53.htm bach wrote: I have done a little research and I have found a few threads but they are well out of my league. I need to create a menu to the menu bar in 2003. _Price_List_ _G_et Data P_r_e Printed _P_rint ------------------- _S_ave I would be greatful is someone could give me a hand and explain the code. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Thanks, There is alot of code there for the create menu. Why is an excel spreadsheet used is this the only way to achieve this ?? -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401641 |
#5
|
|||
|
|||
Storing information in a worksheet is not the only way to do this kind of
thing. But it's a very nice way to do it. Once you get the code set up (and John Walkenbach has done that), you can change the worksheet to whatever you want. If you decide to create another addin/workbook, you just update that worksheet again. bach wrote: Thanks, There is alot of code there for the create menu. Why is an excel spreadsheet used is this the only way to achieve this ?? -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401641 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is a shortcut menu? | Excel Discussion (Misc queries) | |||
Help with drop down menu | Excel Worksheet Functions | |||
Excel Menu Problem | Excel Discussion (Misc queries) | |||
right click menu excel | New Users to Excel | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |