Problem loading userform on 'some' computers

[MAPeX]

I have 10 computers that are running Windows 7 and Excel 2010.

I have a spreadsheet that loads a userform when opened.

The userform loads correctly on 6 of the machines but on the other 4 I get the below errors

untitled.JPG

The module it is mentioning is

Please Login or Register  to view this content.

I cant understand why it works on some machines but not others??

Anyone got an idea as to how I can fix this issue?

Thanks in advance

Mike

[mikerickson]

Are the bad machines Macs that are using Excel 2008?
If so, VBA and userforms are not supported.

[Norie]

Mike

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[MAPeX]

Are the bad machines Macs that are using Excel 2008?
If so, VBA and userforms are not supported.

No they are running Excel 2010 as well!

[MAPeX]

Are the bad machines Macs that are using Excel 2008?
If so, VBA and userforms are not supported.

The file is 4.17mb so it says its too large

[MAPeX]

Managed to zip it so it uploaded.

It will error as it looks up a list of users

[Norie]

There's no userform called Calendar1 in the workbook.

[Norie]

Sorry, Calender1.

[MAPeX]

There's no userform called Calendar1 in the workbook.

Norie

I know but that isn't causing me a problem when loading the file.

[Norie]

Mike

In the code you posted the only userform referred to is named Calender1 so I kind of thought that was where the error was.

What the error message is indicating, as far as I can see anyway, is that there's some control on that userform that isn't available to the user so it can't be loaded.

[MAPeX]

Norie

I think its something to do with the usernamewindows() function, or at least the API call for the function. I just cant get my head around it

[Norie]

The error is about not being able to load an 'object', there are no objects used or referred to in UserNameWindows.

If there was an error in that function I would expect it to be something to do with not being able to find the API referred to.

Can you try opening the workbook on one of the computers having the problem and going to Tools>References...?

Is there anything marked as MISSING?

[MAPeX]

Norie

Where is the Tools menu to select references in Excel 2010?

Its been a long day

[Norie]

On the main toolbar in the VBE (Visual Basic Environment - ALT+F11, ALT+T+R).

[MAPeX]

Microsoft Windows Common Controls-2 6.0 (SP6) is showing as missing.

You think that could be the issue, if so how do I fix it?

[Norie]

I think you need to find out if you are using any controls from that library before you do anything.

Look for things like ListView, ImageCombo, ProgressBar, Slider..., basically anything not in the standard Control Toolbox.