| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening on same sheet
When I open my excel program if i have been I want it to
always open in the same worksheet i am using Private Sub Workbook_Open() Worksheets("names").Show End Sub it is telleing me i have the wrong code. What am i missing? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
opening on same sheet
Hi
try Private Sub Workbook_Open() Worksheets("names").activate End Sub -- Regards Frank Kabel Frankfurt, Germany Tony wrote: When I open my excel program if i have been I want it to always open in the same worksheet i am using Private Sub Workbook_Open() Worksheets("names").Show End Sub it is telleing me i have the wrong code. What am i missing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a sheet | Excel Discussion (Misc queries) | |||
| Excel blank sheet opening but the sheet has data | Excel Discussion (Misc queries) | |||
| Updating sheet without re-opening... | Excel Worksheet Functions | |||
| HOW TO LOCK THE OPENING OF A SHEET(TAB)? | Excel Discussion (Misc queries) | |||
| How to display a msg box while opening a sheet | Excel Programming | |||
Linear Mode
