I would like my workbook to open to the same page every time it gets opened.
I found the following code in another post he

Sub WorkBook_Open()
WorkSheets("Sheet1").Activate
End Sub

It doesn't work which means that I am doing something wrong. The sheet I
want it to open to is Sheet1 but I have renamed it TOC. I tried to paste it
into THIS WORKBOOK and I tried to paste it into TOC (both in microsoft excel
objects)

Does anyone know what I am doing wrong?
Thanks very much