Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to go to a predetermined sheet on opening
My workbooks are used by a wide community and are sometimes saved down again,
with the curser sitting in the body of a sheet. i want to tell Excel to always open on a named sheet whenever the workbook is opened. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to go to a predetermined sheet on opening
Put this code in the Workbook object :
Private Sub Workbook_Open() thisworkbook.Worksheets("Sheet to start from").select end sub (obviously you need to change the "sheet to start from" ! Rgds Rog -----Original Message----- My workbooks are used by a wide community and are sometimes saved down again, with the curser sitting in the body of a sheet. i want to tell Excel to always open on a named sheet whenever the workbook is opened. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add columns to reach a predetermined value | Excel Discussion (Misc queries) | |||
Excel blank sheet opening but the sheet has data | Excel Discussion (Misc queries) | |||
Advance to predetermined cell | Excel Worksheet Functions | |||
Advance to predetermined cell | Excel Worksheet Functions | |||
How to balance several cells to a predetermined value | Excel Discussion (Misc queries) |