View original (French)

Define a file-open tab - Excel

Solved
Kassor Posted messages 25 Status Member -  
Kassor Posted messages 25 Status Member -
Hello,

After doing some research, I unfortunately haven't found a solution to my problem, so I’m turning to you!

I created an Excel file with more than 600 sheets, and on a sheet called "Sommaire" I have several links to go directly to the other sheets.

My question is simple: can I configure my file so that when it is opened, it lands directly on this "Sommaire" sheet and not on any other sheet?

Thanks in advance!

Configuration: Windows XP / Firefox 3.6.3

3 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

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

    to copy into the ThisWorkbook module of VBA

    alt+F11
    Ctrl+R
    click on ThisWorkbook
    paste
    --
    :-x
    0