Good evening, I would like to know how to open a workbook on a specific sheet, for example "Sheet2"? Thank you Configuration: Windows XP Excel 2002 SP-2

Excel - Open workbook on a specific sheet : CCM

Answer 1 / 5

mod77 Posted messages 1320 Registration date Status Member Last intervention 53

But yes, here is what I just found:

Private Sub Workbook_Open()

ActiveWorkbook.Worksheets("Sheet2").Activate

End Sub

Answer 2 / 5

Le Pingou Posted messages 12273 Registration date Status Contributor Last intervention 1 476

Hello,
It's possible, ^^coco^^, as follows:
Put this procedure in [ThisWorkbook]

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

No comments, it's my day of kindness!

Regards.
The Penguin

mod77 Posted messages 1320 Registration date Status Member Last intervention 53

Thank you, Le Pingou, I realized that I had forgotten this significant detail nonetheless.

nabil

To have this run automatically on opening, use the following macro name:
Auto_Open
macro -->
Sub Auto_Open()
Sheets("sommaire").Activate
End Sub

sourine

super Nabil, thank you!

cademe

In 2016, it still works. Thank you, Nabil.
Cathy

Answer 3 / 5

Anonymous user

OK, but this is not possible...
--
Coco

Answer 4 / 5

mod77 Posted messages 1320 Registration date Status Member Last intervention 53

Certainly, but the goal is to save one's work and not have the constraint of having to return to sheet2 before saving.

Answer 5 / 5

Anonymous user

Hi,

You open Excel, you go to Sheet2 and save your file.

See you later
--
Coco

mod77 Posted messages 1320 Registration date Status Member Last intervention 53

Yes, but when you close the workbook on a different page, it will reopen on that other page when you open it again.

Anonymous user

If you change sheets without saving, it won't do anything...
--
Coco