Macro stopped working - object error

[theta]

Hi

I have been analysing a macro left behind by a previous employee who was unable to complete the project. It has suddenly stopped working giving me an 'object not available on this machine' error. The code is :

Private Sub UserForm_Initialize()
   'UserForm_Initialize: This runs when the form is loaded.
    On Error GoTo ErrHandler
    With Me
       .progProgBar.Min = 0
       .progProgBar.Value = 0
       .Repaint
    End With
TheEnd:
    Exit Sub
ErrHandler:
    Call LogErr("UserForm_Initialize", Err.Number, Err.Description)
    GoTo TheEnd
End Sub

Any ideas guys, this has presented me with a big problem as the other macros all run after this.

 

[Weaver]

Has the userform been edited? Perhaps objects have been removed or renamed?

 

[theta]

Looks like a progress bar has been deleted (named "progProgBar") but cant find the progress bar object to draw/insert a new one?

 

[theta]

Ah...the progress bar is not availabe on the toolbox anymore?

It was available but now it has disappeared (using Excel 2007)

How can I get this back (can't see anythig under Tools > Additional controls)

When I open it with 2003 I can see the progress bar ?

 

[Weaver]

Check to see if you have a missing reference in the project, although usually, I'd expect a warning message if you did.

I can't check what's available in 2007 right now, but I tend to write % complete to the status bar in most of my 2007 developed apps rather than use a prog bar