VBE "Help"
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 |
VBE "Help"
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 |
All times are GMT +1. The time now is 01:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com