As Sunnyside reports, the problem can be linked to the Progress Bar control, although this is not the only one that resides in the broken reference. These are the steps to fix the problem:
1. Open the .xls file in question and click OK after getting the error mentioned above.
2. Open the Visual Basic Editor (Alt+F11)
3. Open (if they are not already open) one of the modules or code behind forms
4. Click on Tools / References...
5. In the pop-up window click on Browse...
6. Navigate to [Your Windows Directory]\System32 (it may open by default)
7. Type MSCOMCTL.OCX (you'll see it in the auto-select options before you finish typing)
8. Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6)
9. Click on Debug\Compile VBAProject to verify that the problem is solved
10. Save the file.
Partager