Excel2000 Macros not working in Excel 2002

  • Thread starter Thread starter Andre Croteau
  • Start date Start date
A

Andre Croteau

Hi

I have created an Expense report spreadsheet in Excel2000 with macros. Each
of the sheets are protected, and access to my VBA codes is also password
protected.

I've sent this file to all the company's employees. Everything works well,
except for the one colleague who has Excel 2002, and when he tries to use
the macro buttons, error messages pop up everywhere!

What needs to be done for the file to work without a glitch?

Thanks

André
 
Knowing what the addin does when it errs would help. Knowing what the error messages says
would help. So you're the only one that can solve this. Unless installing Analysis
Toolpack helps, and unless he's got macros disabled and that's what the boxes tries to
tell him, then I suggest you (or he) unlock the vba project on that computer. This way a
Debug option appear on errors and you'll be able to spot what's wrong.
 
Andre

You don't give any details of the error messages, so difficult to tell, but
there may be missing reference libraries on that machine.

Ask your colleague to open the VB Editor and check Tools>References to see if
anything is marked "missing".

OR re-post with some error details.

Gord Dibben Excel MVP
 
Back
Top