auto open a particular worksheet when workbook opened

[racheljane]

Hi,
Can anyone tell me the vba code to automatically open sheet one when a workbook is opened? At the moment it opens on the page on which the workbook was last saved.
Thanks

 

[dave3009]

Hi There

Welcome to the board

Private Sub Workbook_Open()
Sheet1.Activate
End Sub

Ought to do it.

KR


Dave

 

[racheljane]

thanks but it still opens up on the last saved page - is there something else I need to do? I'm quite new to vba. I've just saved this code in a module called auto_open. All the other macros I've recorded need a button to be pressed to activate them. ????

 

[Peter_SSs]

I've just saved this code in a module called auto_open.

That's the problem.

In the Visual Basic window, double click on "This Workbook" and paste the code there.

If that doesn't work, try changing the middle line to
Sheets("Sheet1").Activate

 

[racheljane]

Sorry to be a pain - it still doesn't work??? If I double click in the vba window on 'this workbook', it just opens all the modules that I have.

 

[ADAMC]

Hi RachelJane,

At the top of excel where you have a command menu File Edit etc you will see a little excel icon in the top left next to 'File'

Right click this and choose view code.

Paste the code in there!

Also another thought...Is your sheet called Sheet1?

If not replace sheet1 with your sheet name:

Private Sub Workbook_Open() 
Sheets("Mysheetnamehere").Activate
End Sub

 

[racheljane]

HI AdamC

It doesn't give me the option view code, only save or import file. Thanks for your patience!
Rachel

 

[ADAMC]

Hi Rachel.

Thats because you are right clicking on the visual basic editor commandbars.

Return to excel so your sheet is visible then repeat as above.

Let me know if this helps

 

[racheljane]

Hurray! It works thanks so much for your help - sorry for being dim

 

[ADAMC]

Rachel,

Your very welcome, no need to apologise, if it wasnt for this forum id also be DIM!