Excel - Open workbook on a specific sheet Solved

Question

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

mod77 · Accepted Answer

But yes, here is what I just found:   Private Sub Workbook_Open()  ActiveWorkbook.Worksheets("Sheet2").Activate  End Sub

Anonymous user · Answer

Hi,  You open Excel, you go to Sheet2 and save your file.  See you later -- Coco

mod77 · Answer

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

Anonymous user · Answer

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

Le Pingou · Answer

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

Excel - Open workbook on a specific sheet

5 answers

Open and rename .mdi files

Camera on samsung a26 5g

Very slow laptop

How to purge my email inbox?

Remove leading zeros in printouts

Laptop won't start

I need a bit more detail to help with javascript. what are you trying to do or what's the issue you're facing?

Mailbox

Printer connection

Difficulties changing password on yahoo mail