Code won't run on colleagues PC

[JasperD]

Hi guys,

I've got this weird problem with a sheet that I'm making and updating for my colleagues.
I don't think the problem is in the sheet, but more in one of my colleagues excel version's or settings, but here goes

When opening the sheet, the workbook_open crashes -- and on "LEFT(variable, 3)" code.
The error is that it won't recognize "LEFT" as a command, but thinks its a reference to another sub, so it says something like "subrouting LEFT" is not available in this workbook.

To me, this doesn't make sense at all and I've got no idea how to fix this.
Anyone got any bright ideas?

The code up to the "LEFT" part below :
On all other computers, it runs fine by the way...

Please Login or Register  to view this content.

Thanks for any help!

[Kaper]

Indeed strange.
The first thing which comes to my mind is that there is a sub called Left in Personal.xlsb on this particular computer.

Of course instead of

Please Login or Register  to view this content.

one could use

Please Login or Register  to view this content.

But it does not cure the reason.

[JasperD]

Problem solved - turned out his "MSCOMCT2.OCX" was damaged / missing and therefore one of the add-ins didn't work.
Replacing it fixed it.

Thanks for thinking along