progress indicator help

[ajsloss]

Just a quick question about progress indicators for Excel2007.

I set up my progress indicator like the one displayed here:
http://spreadsheetpage.com/index.php/site/tip/displaying_a_progress_indicator/

I have this sub:
Sub UpdateWorksheets()
UpdateWorksheetsProg.LabelProgress.Width = 0
UpdateWorksheetsProg.Show
End Sub

I then have the user form UpdateWorksheetsProg that calls the subroutine RefreshQueries.

Is there a way to have this all come from RefreshQueries? That is, can I start the RefreshQueries subroutine, have it show the userform, then go back into RefreshQueries so that I don't have to clutter up my macro manager with two macros (UpdateWorksheets and RefreshQueries)?

Thanks in advance for your help.