Creates Excel menu on the fly, list of menu items, command actions, and icons need to be in format of ANStrList.
Icons to be passed are FaceIDs, Excel FaceIDs, get list of FaceIDs from http://Mydev.net/?DevID=J9GIMEFSG9
Tested in Excel 2016
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com
Linkedin LoginANStrListCaptions, ANStrListFaceIDs, ANStrListCommands
ExcelMenu_onfly "Caption1{{$C$}}Caption2","44{{$C$}}55","Command1{{$C$}}Command2"
see screenshots
see screenshots
Views 3,693
Downloads 1,421
CodeID
DB ID