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

Answer 1 / 3
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