View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Looking for Lotus 123 menu equivalents



I realise this wont give you a full map
of 123 menustructure but might put you on the road..



even in Excel2003 it's still there.

options/tools/transition
set the / as menu key
select the lotus 123 help option
check Transition navigation keys

now manually type a / in a cell
a dialog with interactive menuing should pop up.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

Dave wrote in message
:

I've just been given the task of converting a very old Lotus 123
spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really
have a problem with the VBA programming, but can't find a listing of
the old lotus menu structure for use in interpreting the macros.

As an example, one cell of a multi-cell keyboard macro contains
{GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109~.
Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~
does not.

Does anyone know of a listing of the '/' menu commands so that I can
begin to decipher what these macros do?

Thanks in advance for your help.

Dave