Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I copied the code from the article you suggested, however Case 4
gives an error - Method or data member not found (Error 461) in the line SubMenuItem.Controls.Add(Type:=msoControlButton) Any suggestions ? This is the code for Case 4: Case 4 ' A SubSubMenu Item Set SubSubMenuItem = SubMenuItem.Controls.Add(Type:=msoControlButton) SubSubMenuItem.Caption = Caption SubSubMenuItem.OnAction = PositionOrMacro If FaceId < "" Then SubSubMenuItem.FaceId = FaceId If Divider Then SubSubMenuItem.BeginGroup = True End Select Row = Row + 1 Loop -- HJN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help - Jacob Skaria has previously been helping | Excel Discussion (Misc queries) | |||
Congratulations, Jacob Skaria... | Excel Discussion (Misc queries) | |||
Previously helped by Jacob Skaria -- need more help | Excel Discussion (Misc queries) | |||
Ping Jacob Skaria | Excel Worksheet Functions | |||
Menu creater - Dave Peterson | Excel Programming |