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 Excel Training and help » VBA
VBA
Resolved · Low Priority · Version Standard
Thu 7 Feb 2008, 16:37Delegate Edward said...
Edward has attended:
Excel VBA Intro Intermediate course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
VBA
How do you get a macro to function automatically on opening of a workbook?
Tue 19 Feb 2008, 16:22Trainer Carlos said...
RE: VBA
Hi Edward
To run a macro when the workbook opens you need to do the following:
1. In the VB Editor double click "This Workbook" in the project window
2. The code window for "This Workbook" appears
3. In the drop down area at the top select Workbook. The Open Event Procedure appears.
4. Call the macro as shown below:
Private Sub Workbook_Open()
Call MyMacro
End Sub
Hope this helps
Carlos
Training information:
See also:
|
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. |
Excel tip:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |
