I am stumped as to why the 1st of the 2 Change Events below in one Workbook works without problems. But the 2nd one, in another Workbook causes a RunTime 91 error when I close the Workbook?
Private Sub ComboBox1_Change()
Dim wt As Worksheet
Set wt = ThisWorkbook.ActiveSheet
ActiveSheet.[e4].Select
End Sub
Private Sub ComboBox1_Change()
Dim wt As Worksheet
Set wt = ThisWorkbook.ActiveSheet
ActiveSheet.[i7].Select
End Sub
Private Sub ComboBox1_Change()
Dim wt As Worksheet
Set wt = ThisWorkbook.ActiveSheet
ActiveSheet.[e4].Select
End Sub
Private Sub ComboBox1_Change()
Dim wt As Worksheet
Set wt = ThisWorkbook.ActiveSheet
ActiveSheet.[i7].Select
End Sub