Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Execute a macro starting excel ?
- Thread starter cesarsoto
- Start date
place the code into the workbook "open" event....
alt+f11 > dbl click "this workbook" from left pane and then switch (from drop down in right pane) from general to workbook...then in right most drop down,...select "open"
paste your code there....removing sub you_macro () and the all but the last "end sub"
you should have
Private Sub Workbook_Open()
your code here
End Sub
alt+f11 > dbl click "this workbook" from left pane and then switch (from drop down in right pane) from general to workbook...then in right most drop down,...select "open"
paste your code there....removing sub you_macro () and the all but the last "end sub"
you should have
Private Sub Workbook_Open()
your code here
End Sub
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question
- Locked
- Question