Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Open event

Open event

ResolvedVersion 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:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips

Open event

Open event

RE: Open event

Access articles

Access tip:

Prefixed Autonumbering