VBA code not working on all computers??

[bhinrichsen]

Hi all, i have a spreedsheet that has macro's and vba code. The issue i am coming across is that a couple of computers in our organisation aren't working with the vba code in particular. i have set the trust centre settings to enable all macros and also have ticked the box to Trust access to the VBA project object model. All other computers work with these settings. Any advice is greatly appreciated.

Thanks again.

 

[Leith Ross]

Hello bhinrichsen,

There are couple possible causes I think of.

• VBA compatibility issues like running 2007 code on 2003 or earlier.
• Network users may not have the necessary permissions to perform some the macro actions.

Without knowing the specific errors you are encountering, it almost impossible to offer any further suggestions.

 

[bhinrichsen]

The computer that is having the issue is running windows 7 and excel 2007. the terminals that are working fine are also running excel 2007. there are no error messages coming up or anything its simply that the code i have written in the worksheet simply doesn't work on the computer? Hope that helps out a bit? i am totally baffled on this one.

 

[Leith Ross]

Hello bhinrichsen,

What is the code supposed to do that it isn't doing?

 

[ChrisM]

Where you normally run into a problem is when you have to add a reference to your VBA project. Did you have to do that? Anytime (mostly) that you add a reference you have to consider the version of that reference (use the lowest version that everyone might have) or whether other users' computers even have that reference available.

If that's not it, have you added any fancier controls like user forms?

 

[bhinrichsen]

Hi all, the code simply allows multiple selections to be chosen from a drop down list and entered onto the one line. no references have been used in this code either. strange thing is that the computer that isn't working is a standard pc, the ones that do work fine are simple terminals running server 2003?