Cross-Computer Macro Issue

So recently I created an worksheet for our field personnel, in this worksheet there is one vba-function, and three subroutines. I sent the sheet out, and the field guys have been filling the sheet out and sending it back to me.

After working great for a few weeks, now when they send the sheet back, the vba function does not work (#Value not #Name?) - the code is still there, so there should be no reason it's not working. When I call the field guys they say it works fine and they can see all the numbers on their end, but after emailing I see nothing but #Value.

Any ideas as to how to fix this? I have already been through the obvious such as making sure we have the same excel version, checking for the same references etc.

There is no reason it shouldn't work - alas here I am

Thanks for the help

Also, the 3 subs work, but the buttons to launch the subs don't work, so its as if the developer/vba quit talking to the excel sheet for some unexplainable reason

Yeah I tried that, with the new broken worksheet it doesnt step through at all. In that its like the sheet isn't communicating with vba anymore

And when I try to delete any of the tabs it immediately crashes excel

Hi, have you updated your PC? I had a similar issue and this fixed it.

See here, if it sound similar?

HTML Code: 

Good luck
C

Thanks Mr. C, I thought that to, so yesterday I ran through that workflow, and it didn't seem to solve the issue, super weird right?

Also, if this helps, we are running excel 2007

And windows 7 professional

bump for new crowd, really have no idea why this isnt working. Tested with my personal computer at home (which runs 2010, so not even the same issue of excel) and was able to read/write/see everything fine both there and when sending it back to the original computers.

Hey john,

ActiveX Settings is the first thing I checked out, rechecked it and our settings are indeed set the same.

I have also run through the activex reset workflow multiple times and that did work either.

The sheet really works on your computer? I tried this same sheet on a personal computer at home and it did not work there either.

John,

No worries, that's good news then that the worksheet works elsewhere

Appreciate the help, rep added