Workbook_BeforeClose compile error: Variable not defined help

[Pookiemeister]

What this code is suppose to do is look to see if any of the worksheet names equals Exhibit "I" or "page 2". If they do exist then before closing the workbook don't save it and then close the workbook.

Actual First Worksheet Name is Exhibit "I" and the second worksheet name is page 2.

Unfortunately, I am getting a compile error: Variable not defined and the following word "Worksheet" is highlighted in blue.

If [COLOR=#0000FF][B]Worksheet[/B][/COLOR].Name = ("Exhibit 'I'") Or ("page 2") Then

Full Code Below:

Private Sub Workbook_BeforeClose(Cancel As Boolean)    
    If Worksheet.Name = ("Exhibit 'I'") Or ("page 2") Then
        ThisWorkbook.Save = False
        ThisWorkbook.Close
    End If
    
End Sub

Thank You

 

[MARK858]

Untested and assuming the sheet names in your description is correct...

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
    If ws.Name = "Exhibit ""I""" Or ws.Name = "page 2" Then
        ThisWorkbook.Save = False
        ThisWorkbook.Close
    End If
 Next
End Sub

 

[sericom]

Try this

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Sheets
        If ws.Name = "Exhibit ""I""" Or ws.Name = "page 2" Then
            Application.DisplayAlerts = False
            ThisWorkbook.Close
            Application.DisplayAlerts = True
            Exit For
        End If
    Next
End Sub