How to Prevent MISSING : Microsoft common Controls-2 6.0 (SP6) Error

[bdouglas1011]

I have code that runs on a 64 bit computer with 32 bit version of office and everything runs great.

The problem is I have distributed to people in the field and every now and then I get a Compile error in hidden module:

I can get around this by going into references in the VBA and unchecking the file showing (MISSING : Microsoft common Controls-2 6.0 (SP6))
After doing this it works


Is there a way to fix this problem from happening???

[romperstomper]

Uncheck it on your file, save it and then distribute it. If you don't need the reference (and it appears you don't) you should remove it.

[Leith Ross]

For those who are interested,

Microsoft Windows Common Controls-2 6.0 includes the following ActiveX controls:

Microsoft Animation Control
Microsoft UpDown Control
Microsoft MonthView Control
Microsoft Date and Time Picker Control
Microsoft Flat ScrollBar Control