ExcelMenu_onfly

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

CodeFunctionName What is this?

Public

Tested

Original Work

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 Login

ANStrListCaptions, ANStrListFaceIDs, ANStrListCommands

ExcelMenu_onfly "Caption1{{$C$}}Caption2","44{{$C$}}55","Command1{{$C$}}Command2"
see screenshots

Views 3,693

Downloads 1,421

CodeID
DB ID