Trying to run MS Excel 2000 macros on MS Excel 2002

Trying to run MS Excel 2000 macros on MS Excel 2002

Post by Jack » Fri, 23 Apr 2004 18:41:37


I have been working on a MS Excel spreadsheet that
contains a number of macros and User Forms and two custom
toolbars. I am working with MS Excel 2000 on a MS Windows
2000 desktop and am based in the United Kingdom. I
emailed the finished spreadsheet to my colleague. She is
using MS Excel 2002 on a MS Windows 2000 desktop and she
is based in Montreal.

When she tried to run the spreadsheet it generated errors
every time it tried to run any of the macros. The error
was as follows: "Microsoft Visual Basic: Unexpected error
(336) in Visual basic." Selecting help brought up further
information: "Activex component not correctly registered:
Error 336".


Can anyone tell me what the cause of this problem is?

Thanks

Jack