auto run macro on workbook open

  • Thread starter Thread starter Mcasteel
  • Start date Start date
M

Mcasteel

How do I get my customized form "frmCustEnrollment" to run automaticall
when the entire file or workbook "CEF.xls" is opened
 
Hi

in the VBE window, double click on the ThisWorkbook module of your workbook,
from the top left drop down box choose Workbook and the workbook_open
procedure should be created for you
in here use
frmCustEnrollment.show

Hope this helps
Cheers
JulieD
 
Hi
put your code in the workbook_open() event procedure of your workbook
 
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

How to run auto-open macro in Excel 2007? 3
Unwanted workbooks on startup 2
Opening a list of Excel files and run a macro in each 17
How to Unlock Excel Workbook protected by MACRO Password 6
Macro shortcuts are running macros in different open workbook 3
Calling subroutine defined in another workbook (autostart workbook) 5
COM addin won't connect when workbook opened via another workbookfrom another instance 3
VBA Debug Issue 2

Back
Top