I have a macro in an add-in (located in the XLSTART folder) which is run
from a toolbar.

I want a routine to run if sheet1 of the current workbook is called "Order
List 1"

If Sheet1.Name = "Order List 1" Then
'Run a routine
Else
MsgBox "This program only works on the `Internet Orders & Packing Sheets'
spread sheet"
Exit Sub
End If

This works if you only open 1 workbook at a time, but if you have more than
one open it sometimes defaults to the sheet1 name of the first worksheet
opened.

Thanks