What does "/xm" do in a 123 macro?

[Carl Rapson]

I've come across the command "/xmmenu~" in a Lotus 123 macro that I am
converting, and I can't figure out what it's for. There is a range named
"menu", and it contains text strings that look sort of like a set of menu
items with associated macro commands. Is "/xm" an undocumented command for
executing some kind of macro menu? Or is it maybe an older command that is
no longer available (I am using 123 version 9.8). Where can I find
information about this command?

Thanks,

Carl Rapson

[Harlan Grove]

"Carl Rapson" <cara...@netscape.net> wrote...

/xm is 123 Release 1's equivalent to either {menubranch MENU} or {menucall
MENU} in later versions, I don't remember which. This will be nasty.
Theoretically, the best way to translate this would be using a custon
toolbar resembling a menu. Next best would be the way later versions of 123
deal with these commands: putting them into a list box in a dialog.

Unfortunately, UI programming is something I've avoided, so I'm no help with
this. I understand roughly how this needs to be done. 123 custon classic
menus such are defined by ranges having one column per menu entry. In each
column, the top row is the text that will appear in the menu, the 2nd row is
the menu prompt - text that appears below the menu when the given item is
selected, and the subsequent rows are the macro statements run if the user
selects that menu item. If /xm == {menucall .}, then you could bundle each
of the macro statements in each column into separate Excel/VBA macros,
display either a custom toolbar/menu or listbox in a user form (dialog), and
use a Select statement based on the menu results to choose the macro to run.

I'm crossposting this on purpose to microsoft.public.excel.programming
because the people there are more likely to be of help than me when it comes
to Excel/VBA UI programming.

[Harlan Grove]

I just remembered something I read a while ago about doing this. You can use
Tools > Customize to create your own toolbars, and they can be made to
function similar to 123 custom classic menus. I've uploaded a very simple
example to ftp://members.aol.com/hrlngrv/L123menu.xls . See if you can adapt
it. Note: it contains macros.

[Carl Rapson]

Once again, thanks.

Carl Rapson

"Harlan Grove" <hrl...@aol.com> wrote in message
news:Od3kAg$WDHA...@TK2MSFTNGP12.phx.gbl...