Home |
Search |
Today's Posts |
#1
|
|||
|
|||
open at define work sheet
Iwant a shared workbook to always open at a define work sheet (Front page).
I have entered the following in vb under workbook but it does not work. I entered the following Private Sub Workbook_Open(sheets "front page".select) End Sub please help Kitty |
#2
|
|||
|
|||
open at define work sheet
Put the following code in the ThisWorkbook code module:
Private Sub Workbook_Open() Me.Worksheets("Front Page").Select End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kit" wrote in message ... Iwant a shared workbook to always open at a define work sheet (Front page). I have entered the following in vb under workbook but it does not work. I entered the following Private Sub Workbook_Open(sheets "front page".select) End Sub please help Kitty |
#3
|
|||
|
|||
open at define work sheet
kit wrote:
Iwant a shared workbook to always open at a define work sheet (Front page). I have entered the following in vb under workbook but it does not work. I entered the following Private Sub Workbook_Open(sheets "front page".select) End Sub please help Kitty Hi Kitty, Were not too far : Private Sub Workbook_Open() sheets("front page").select 'can try also : sheets("front page").activate End Sub @+ FxM |
#4
|
|||
|
|||
open at define work sheet
Works brilliantly, thank you
Kit "Chip Pearson" wrote: Put the following code in the ThisWorkbook code module: Private Sub Workbook_Open() Me.Worksheets("Front Page").Select End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kit" wrote in message ... Iwant a shared workbook to always open at a define work sheet (Front page). I have entered the following in vb under workbook but it does not work. I entered the following Private Sub Workbook_Open(sheets "front page".select) End Sub please help Kitty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
How Can I track changes in a Work Sheet? | Excel Worksheet Functions | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
Do you have a work in progress sheet | Charts and Charting in Excel |