You must paste that code in the ThisWorkbook code module.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tia" wrote in message
...
Hi

i m working on a timesheet workbook and i have been trying to use VBE
so each time i open my workbook i always see the main sheet first so
i can select my choice what im sure about is that im doing something
wrong because its not working at all :( im using excel 2007 i have
seen a demo i tried it and its not working may be b i have links in it
is there is any excel demo 2007 so i can see what are the steps and
the code that i need to use so i can have what i want ?

This is what im doing :

VBE- i select the main sheet-view code-i paste the code i save- i open
another sheet save and close "what am i doing wrong" i open again and
i can see the main sheet opened always the last sheet that i have been
using

Private Sub Workbook_Open()
Sheets("Main").Select
End Sub

Tia