Worksheet Default

  • I searched the forum but couldn't find my answer.


    I like to have one specific worksheet as default/open everytime this specific workbook opens. This sheet is my main navigation menu that contains many commandbuttons that will take a user to certain worksheets.


    Thanks for the help.


    Paul

  • Re: Worksheet Default


    Hi Paul,


    Try this:


    [vba]
    Private Sub Workbook_Open()
    Sheet3.Activate
    End Sub
    [/vba]


    Change the sheet reference to your requirement. And place this code in Workbook open event.


    HTH.

  • Re: Worksheet Default



    Thanks. Tried it and got 'run time error 424. Object required'. I am sure it's me. I am new to this.
    I used this on 'Open' event. My sheet name is 'Main'. what did I do wrong?
    [vba]
    Private Sub Workbook_Open()
    Main.Activate
    End Sub
    [/vba]

Participate now!

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