Workbook always opens at a specific sheet and cell

Z

Zee

I have a workbook consisting of many sheets. How do I make sure that
everytime I open the work book, it would directly point to a specific sheet
and cell?
 
F

Frank Kabel

Hi
put the following code in your workbook module (not in a standard
module).

sub workbook_open()
me.worksheets("sheetx").activate
end sub
 
I

icestationzbra

methinks the original poster also wanted to activate a particular cell:

Sub workbook_Open()

Sheet2.Range("B3").Activate

End Su
 
F

Frank Kabel

Hi
not tested but I think you first have to activate the sheet. So
combining yours and mine the OP may require:
Sub workbook_Open()
With me.worksheets("sheetx")
.activate
.Range("B3").select
end with

End Sub
 
I

icestationzbra

i use xl 2k2, and i checked Sheet2.Range("B3").Activate before posting
i did not need to select the sheet, it automatically opens with sheet
selected and B3 activated. thats the reason i tested on sheet2 and no
sheet1
 
Top