98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Open event
Open event
Resolved · Medium Priority · Version 2007
Wed 17 Mar 2010, 15:46Delegate 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:17Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Relationship mapsIt 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 |
