Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |