| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Opening workbook on the same page every time
I would like my workbook to open to the same page every time it gets opened.
I found the following code in another post he Sub WorkBook_Open() WorkSheets("Sheet1").Activate End Sub It doesn't work which means that I am doing something wrong. The sheet I want it to open to is Sheet1 but I have renamed it TOC. I tried to paste it into THIS WORKBOOK and I tried to paste it into TOC (both in microsoft excel objects) Does anyone know what I am doing wrong? Thanks very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening a new page with hyperlinks in excel | Excel Discussion (Misc queries) | |||
| Code for opening a workbook at a specific time!?! | Excel Discussion (Misc queries) | |||
| How to avoid opening an empty workbook every time I open a file? | Setting up and Configuration of Excel | |||
| Opening a Title Page | Excel Worksheet Functions | |||
| How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
Threaded Mode
