VBE "Help"

[Tia]

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

 

[Bob Phillips]

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)

 

[Don Guillett]

Your code needs to go in the ThisWorkbook module instead of the sheet
module.