The right Menu

B

bach

Hi guys,

I have done a little research and I have found a few threads but the
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 th
code.

Regards

Bac
 
A

Anne Troy

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
 
B

bach

Thanks,

There is alot of code there for the create menu. Why is an exce
spreadsheet used is this the only way to achieve this ?
 
D

Dave Peterson

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.
 
Top