Open event

Resolved · Medium Priority · Version 2007

Wed 17 Mar 2010, 15:46 Delegate Aquila said...

Aquila has attended:
Excel VBA Intro Intermediate course

Open event

Hi.

I want my workbook to be on a specified sheet when it is opened. How would I go about doing this? Would it be in my macro codes, or is there a excel setting for this?

Thanks

Wed 17 Mar 2010, 16:17 Trainer Stephen said...

RE: Open event

Hi Aquila

Thanks for the question

In the project explorer select the "ThisWorkbook" object.

Select the Workbook object (from the left hand combo above the code window). This will automatically create an on open event.

Then write the code to select the worksheet, e.g

sheets(2).select

Hope this helps

Regards

Stephen

Wed 24 Mar 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips