tag:blogger.com,1999:blog-6554229332422482192.post1844016155923777181..comments2007-08-10T19:50:52.089-07:00Comments on Helen Bradley - MS Office Tips, Tricks and Tutorials: AutoFormat an Excel cellProjectwomanhttp://www.blogger.com/profile/18407289311564764370noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6554229332422482192.post-65272517975486786372007-08-10T19:50:00.000-07:002007-08-10T19:50:00.000-07:00Sure, can do. Probably the thing you are doing whi...Sure, can do. Probably the thing you are doing which you shouldn't be doing is to put the Auto_Open macro in your Personal.xls file. The Auto_open macro should go in the workbook itself in a new module. <BR/><BR/>I copied and pasted the code from this post directly into a new module in a new workbook, saved it and closed it and opened it and it works just fine in Excel 2003. <BR/><BR/>If you continue to have problems, post with more details of what the issue is or email me the Excel file at helen@helenbradley.com<BR/><BR/>cheers<BR/><BR/>HelenProjectwomanhttp://www.blogger.com/profile/18407289311564764370noreply@blogger.comtag:blogger.com,1999:blog-6554229332422482192.post-1371967502391145422007-08-07T01:39:00.000-07:002007-08-07T01:39:00.000-07:00I cannot get Auto_Open working inside excel 2003 -...I cannot get Auto_Open working inside excel 2003 - can you help?<BR/><BR/>parkin_m@hotmail.comMichaelhttp://www.blogger.com/profile/15233606011007245707noreply@blogger.com