| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Workbook on Specific Worksheet
Hi all
I am trying to get my workbook to open on the cover sheet. I have tried to use 2 to 3 codes but each time it comes up as run time error 9 out of range or opens on the last sheet I was working on. what can I do? Here is one of the codes, I have put it into the ThisWorkbook section in VBA Projects. The Sheet is named Cover and it is the last on my list at the bottom of the workbook and Sheet 14(Cover) in the Projects list. Regards Chris Private Sub Workbook_Open() Sheets("Cover").Activate Range("A1").Select End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| force excel workbook to open to a specific worksheet | Excel Discussion (Misc queries) | |||
| OPEN A WORKBOOK TO A SPECIFIC WORKSHEET | Excel Discussion (Misc queries) | |||
| Open Workbook to Specific Worksheet? | Excel Discussion (Misc queries) | |||
| How to open a workbook on a specific worksheet. | Excel Worksheet Functions | |||
| Open workbook to specific worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
