Checking Tab Names

[garydp]

Is there a way of checking the tab names when a command button is clicked. what i want to do is sheck to see if there is a tab with the same name as the sheet that it is trying to generate. if there is then a message box will let the user know that the tab name is taken.

[Bob Phillips]

Build a Function that tells you

[vba]

'-----------------------------------------------------------------
Function SheetExists(Sh As String, _
Optional wb As Workbook) As Boolean
'-----------------------------------------------------------------
Dim oWs As Worksheet
If wb Is Nothing Then Set wb = ActiveWorkbook
On Error Resume Next
SheetExists = CBool(Not wb.Worksheets(Sh) Is Nothing)
On Error GoTo 0
End Function
[/vba]