Activate Certain Sheet When Open a Workbook

[qiqinuinaifen128]

Dear Pros,

I have a question regarding the Excel VBA.
I have a workbook which has about 50 sheet. Is it possible to make the wookbook always activate sheet1 when the wookbook was open?

I know there is a private sub sth like below

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sub

But can anyone show me step by step how to do it. I am a beginner. I only know create macro and assign macro. So i don't know where to start although i find this code in internet.

I would appreciate if anyone can help me.
Thank you in advance and hope to hear from you soon.

 

[VoG]

Right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

Then save, close and re-open the workbook to see the effect.

 

[qiqinuinaifen128]

Thank you for you reply.

I'm using the excel 2007, i can't see and logo at the menu bar there.

 

[Smitty]

Yeah, '07 has a much different interface. In '07 you can still hit ALT+F11 to open the VBE, then open the ThisWorkbook module. You can put Workbook level events, like Open, there (that's where Peter's code should go).

HTH,

 

[qiqinuinaifen128]

ADVERTISEMENT

Hi,

Sorry to ask you stupic question. I am a beginner, can you guide me step by step. After i press ALT F11 and i see a window of VBA, the right site i can see the properties window, and i can see all my worksheet and my micro (Module), how should i go?

 

[VoG]

You should see something like this:

Double click on ThisWorkbook and paste in the code.

 

[qiqinuinaifen128]

Thank you for you help.