This is a snippet of code that i wrote for for my ex-rommies nambi,gagan & Arun (nizam)
they had asked about opening excel file with a preset sheet being shown first always ..,
and hear is how it is done.
1. open ur excel file
2. press <Alt> + F11
3. u will be looking at an IDE now.,. ( something very similar to VB )
4. on the left side .., u will see a " project browser window " ( with Project - VBAproject as title )
5. double click on the "This Workbook" object..,
6. a codeing region opens up
7. Paste this code into that area
Private Sub Workbook_Open()
Worksheets(3).Activate
End Sub
8. Change the number (3) to the sheet number that u want to open every time the file is opened..,
