Try something like this:
For Each sh In ActiveWorkbook.Worksheets
If (sh.Name) < "Password" Then
'do something here
End if
Next

Hope that helps ya,
Ryan---

--
RyGuy


"Nico" wrote:

I have a number of tabs in a spreadsheet, I want a simple Yes/No index that
indicates whether or not a tab is present as some tabs will be present for
some managers, but not for others.

How do I do that?

Thanks!