View Full Version : Excel's VB
02-14-2002, 05:54 PM
How do i get a macro to run automatically when I start up Excel? All I know is that it would be part of PERSONAL.xls, but not sure what the right sub() name would be...
02-14-2002, 08:50 PM
I think that the subroutine needs a name of "Auto_Activate" (or something similar). I can't quite remember.
General Kenobi (ret.)
02-14-2002, 08:58 PM
Put it in the Workbook_Load event (I think--I'll check to be sure tomorrow).
02-14-2002, 10:39 PM
In a workbook Module (not in a sheet),
' insert code here
(Tested and working fine on Excel 97 and I believe 2000 as well).
vBulletin® v3.7.6, Copyright ©2000-2013, Jelsoft Enterprises Ltd.