auto run macro on workbook open
 

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

--
Mcastee
-----------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27829

auto run macro on workbook open
 

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

"Mcasteel" wrote in message
...

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


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile:
http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=278291

auto run macro on workbook open
 

Hi
put your code in the workbook_open() event procedure of your workbook

"Mcasteel" wrote:


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


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=278291