Always opening on the same worksheet

    Hey all,


    I have a workbook with loads of various worksheets,, which is shared between a group of us.


    What i want is that each time the workbook is opened it always starts on the same worksheet called 'main'.


    Is this possible?


    Thank you

    Re: Always opening on the same worksheet


    Hi Steve


    use this bit of code


    Code
    Private Sub Workbook_Open()
Worksheets("Main").Activate
End Sub


    Put in ThisWorkbook.


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

    Re: Always opening on the same worksheet


    Quote from Wigi

    Put in ThisWorkbook.


    Press Alt-F11, you come in the VBE environment. Go in the VBA project to "ThisWorkbook". Double click and paste the code in the blank screen appearing.


    Do you succeed?


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

    Re: Always opening on the same worksheet


    Sorry i was meant to say I put it where you said but it still opens on another page (where i last saved the workbook)


    Thanks of ryour help, anby ideas?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login