Lotus Macros in Excel (Office XP)

  • I have an older worksheet that was originally written in Lotus with a macro for data entry. I converted it over to Excel in an earlier version of Excel and the data input macro worked. Since that time we have upgraded to Office XP and now I find when I load the sheet (either the excel of lotus version) that the lotus data entry macro no longer works.

    Is there some setting or more to install to make this work again. I realize that Excel uses VB, but, the older versions still supported the old style macros.

    Thanks in advance

  • I don't have Office XP, so this may not help. In the older versions when you go to the Tools menu and select Options, there is a Transition tab that refers to 1-2-3 and running macros. Is that still there in XP?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!