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?
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