menu in excel

[a_d66]

hello,
I want to desighn a macro on EXCEL that opens a menu on the board that
includes few things that the user has to choose. each one of them will
run another macro or another menu.

I also want to know how do I make a macro running every time I open an
Excel file.

thanks
Alon

 

[Tom Ogilvy]

See Chip Pearson's site
Look at http://www.cpearson.com/excel/events.htm

for the workbook_open event.

and for menus
http://www.cpearson.com/excel/menus.htm#vba

Also
Look at John Walkenbach's site:
http://j-walk.com/ss/excel/tips/commandbars.htm