Define which sheet (tab) opens

[Egg 'n' Bacon]

Probably quite simple, but I can't find out how to specify (with VBA) which sheet is the default one - according to a basic IF.

Here is what I tried (unsuccessfully), in the 'ThisWorkbook' object:

Code: Select all

Private Sub Workbook_Open()

  If Sheets ("Raw_Data").Range("B3").Value = Null Then
    Sheets("Raw_Data").Select
    Range("B3").Select
  Else
    Sheets("Menu").Select
    Range"B3").Select
  End If

End Sub

TIA

[Rudi]

Instead of "Null", use ""

Try:

Code: Select all

If Sheets("Raw_Data").Range("B3").Value = "" Then

You could also use .Value = Empty

[Egg 'n' Bacon]

Thank you, the "" works a treat.