Code wrong

[Aussie_Striker]

Just need help correcting this code. I think it is obvious what I am trying to achieve but have worded it wrongly. Trying to set the file to open on a sheet that is selected on a cell. The two extra criteria would otherwise cause errors so defaults to Manager Page in either case.

Please Login or Register  to view this content.

[JR@SGC]

Hey,

Take a look at this

Private Sub Workbook_Open()
Lara = Worksheets("settings").Range("g8")
If Lara = "click to select choice here" Then Lara = "Manager Page"
If Lara = "" Then Lara = "Manager Page"
ThisWorkbook.Sheets(Lara).Activate
End Sub

Vba did not like 'default' as a name, so i always use names of people i know
so it wont match something vba already uses.


Hope it helps