why dont you activate the first sheet after opening the file. This will
solve the problem of error because you then dont need to have this code
in your workbook.

melody wrote:
Hello everyone,

I have a program that opens an excel template and then checks to see if
the first sheet is selected, if it is then no error but i get an error
irrespective of the fact whether the first is selected or not...i am
pasting the code here and would appreciate it if someone can point what
i am missing.

TIA

#region Excel Check 5: First sheet or multiple sheets selected

if(OptionsData.XLCheckSelectedSheet)----(bool)
{

if(XLwb.Sheets.Count 1 && XLwb.ActiveSheet !=
XLwb.Sheets.get_Item(1))
{
ErrorCounter++;
ProcessError(ErrorCounter, "The first sheet is not the selected
sheet");
}