Thread
:
Looking for Lotus 123 menu equivalents
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Looking for Lotus 123 menu equivalents
I just checked xl97, xl97 & xl2002 and it's there for all
toolsoptionstransition
--
Don Guillett
SalesAid Software
"Dave" wrote in message
...
I tried setting this up but don't have a lotus help option checkbox?
Should
that be in the option/tools/transition dialog?
Dave
"keepITcool" wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]