Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Starting a macro automatically from Workbook_Open (Read 2107 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Starting a macro automatically from Workbook_Open
21.09.09 at 10:34:29
 
Starting a macro automatically from Workbook_Open
 
To start a macro automatically when a workbook opens is easy. A call needs to be made in the Workbook_Open event.
 
In the VB editor, open the source for ThisWorkbook in your project. Then choose from the top dropdowns choose Workbook and then choose Open. Excel will code an empty procedure for you so you only need to code the call to your macro. Please have a look. I am sure you will figure it out.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1