How? Open Workbook to specfic tab & cell?

My Workbook "Fly Ash Tracking 2008".
I am saving & closing Workbook via macro on Sheet Tab: "CLOSING" cell A1.
I need a way that when I open Workbook again it opens with Sheet Tab: "INDEX" cell A1 every time.

Automatic Macro upon opening? OR does Excel have a function that can do this? Either way I need help on how to accomplish. Thanks

Hello N2lectual,

You can add these lines of code to the Workbook_Open Event procedure.

Procedure Code

Private Workbook_Open()

  Worksheets("INDEX").Activate
  ActiveSheet.Range("A1").Select 

End Sub

Sincerely,
Leith Ross

Works, thank you.
n2lectual