Auto start a macro

  • Thread starter Thread starter Victor Lin
  • Start date Start date
V

Victor Lin

I would like to find out how to auto start a macro when I
open a Excel file

Victor
 
Put it in the Workbook_Open event in the ThisWorkbook module.
 
In the workbook:

Option Explicit

================
Private Sub Workbook_Open()

FirstSheet = True
Application.Run ("Main")

End Sub
 
i'm not sure..
but can't you just name the macro "Auto_Open" and it will start upo
opening the file
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with a simple macro 2
Auto fill not working 2
How do I stop Excel from opening all files w/macros & running them 4
The next Grand Theft Auto title has been officially announced 0
Using a macro to create a macro 1
Macro - hide rows that are 0 without an auto-filter 3
Is there a way to force out other editors when Excel 2003 is inautomation mode? 3
Auto numbering in Excel 1

Back
Top