Run a sub or function on program start?
Bob Phillips Wrote: So what was wrong with Workbook_Open? Since XL97, that is the 'proper way to do it. -- HTH RP (remove nothere from the email address if mailing direct) Nothing at all wrong with it, I just couldn't recall "how" to do it.. The sub_auto() just seems much less complicated.. -- RASelkir ----------------------------------------------------------------------- RASelkirk's Profile: http://www.excelforum.com/member.php...fo&userid=1621 View this thread: http://www.excelforum.com/showthread.php?threadid=27804 |
Run a sub or function on program start?
Don't think so RA. It is just that it must go in the ThisWorkbook code
module. Workbook_Open runs whenever the workbook is opened, Auto_Open doesn't if open ed from within another piece of code or automation. -- HTH RP (remove nothere from the email address if mailing direct) "RASelkirk" wrote in message ... Bob Phillips Wrote: So what was wrong with Workbook_Open? Since XL97, that is the 'proper' way to do it. -- HTH RP (remove nothere from the email address if mailing direct) Nothing at all wrong with it, I just couldn't recall "how" to do it... The sub_auto() just seems much less complicated... -- RASelkirk ------------------------------------------------------------------------ RASelkirk's Profile: http://www.excelforum.com/member.php...o&userid=16216 View this thread: http://www.excelforum.com/showthread...hreadid=278044 |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com