calculus87
August 3rd, 2004, 08:17 PM
Hello,
I would like to create, what I believe is known as, a menu. An example of it would be File, or Edit, or View, or Favorites, or Tools, or Help. Anyways I would like to make one in excel. How would I? Thanks
renegade600
August 4th, 2004, 11:23 AM
it is tough to answer without know what operating system or what version of excel. you may be able to set them up using the edit toolbar feature under view.
degsy
August 4th, 2004, 03:50 PM
Heres a tutorial found via google
http://www.cpearson.com/excel/menus.htm
calculus87
August 9th, 2004, 02:39 PM
Hey,
I found a link on the Microsoft website which had this code and was able to help me. Thanks for your time.
Sub Menu_Create()
Dim myMnu As Object
Set myMnu = CommandBars("Worksheet menu bar").Controls. _
Add(Type:=msoControlPopup, before:=3)
With myMnu
' The "&" denotes a shortcut key assignment (Alt+M in this case).
.Caption = "jkhgkjhgjhgkhg"
End With
End Sub
The web site was
http://support.microsoft.com/defaul...502&Product=xlw (http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw)
Thanks