Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Welcome Sheet???
hi
i've got a workbook with many sheets. how do i set it so that sheet1 will show when a user loads the workbook thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Welcome Sheet???
In your Project window click on ThisWorkbook, Choose Workbook in the left dropdown box of the code window, and Choose Open in the right dropdown box of the code window
Put in this code, where "Sheet1" is the name of the sheet you want as your welcome shee Private Sub Workbook_Open() '<<this is provide Sheets("Sheet1").Activat End Sub '<<this is provide ----- Stefano wrote: ---- hi i've got a workbook with many sheets. how do i set it so that sheet1 will show when a user loads the workbook thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |