Please help...

I have been looking for a solution to this problem for a
couple of years now.. but can't seem to get around it..

I have a workbook ([Job Analysis 2004.xls]) with macro
that I run that:

1. Copies a mastersheet within the workbook to a new
sheet.

2. Sets new name of the sheet, let say "04-500"

3. Using the variable LstYrMat"='[Job Analysis 2003.xls]"
& JobNo & "'!$B$23, I create a formula in a cell to link
to sheet "04-500" in last years workbook ([Job Analysis )
2003.xls]"

My problem is that if the sheet did not exist in last
years workbook, when I set the formula in the cell, I get
the "Select Sheet" dialog box. I can't seem to find a way
to dismiss the dialog box programmatically. The user has
to sit there and hit cancel several times.

Any help I can get would be greatly, greatly appreciated.

Jeannie Flores