Hi Experts

The following attached snippet code looks up the data in column N worksheet "New Business" and paste it into column N the worksheet "Scenario 1".....which works fine when the user click the RESET macro button in worksheet "Scenario 1"...

however, here is the question.

I would lke to amend the vba code so that if any one of the following worksheet(s) "Previous Terms" or "New Business" is open in the workbook it works...Point. only one worksheet either "Previous Terms" or "New Business" can be open at any one time....
both cannot be open at the same time....

Public Sub Reset()

With Sheets("Scenario1")
Application.Calculation = xlCalculationManual
Dim rng As Range

Set rng = Range(.Cells(10, 14), .Cells(Rows.Count, 14).End(xlUp))
Dim c As Range
For Each c In rng.Cells
c = WorksheetFunction.VLookup(c.Offset(0, -12), Excel.Range("'New Business'!" & Range(Sheets("New Business").Cells(10, 2).Address, Sheets("New Business").Cells(Rows.Count, 14).End(xlUp).Address).Address), 13, False)
c.Font.Bold = False
c.Font.Color = 0
Next c

.Range("U2").Select
Application.Calculation = xlCalculationAutomatic
End With

End Sub