VBA, How do I Create an On-Open Macro for Excel Workbook

How do I Create an On-Open Macro for Excel Workbook

Author	Message
alf #1 / 4	How do I Create an On-Open Macro for Excel Workbook Hello, me again. Thanks to all the people that responded to my last question, it was very helpful. I created a macro that works wonderfully in Excel. I would like to be able to have this happen automatically when I open the file (or workbook). How do I have the Onopen event call the macro -- I've nosed around in the modules a bit and thought I found the workbook open one, but it didn't work so I must have done something wrong. Again, thanks very much for the help -- it is certainly appreciated! alf also reachable by
Tue, 19 Aug 2003 19:36:49 GMT

Debra Dalgleis #2 / 4	How do I Create an On-Open Macro for Excel Workbook You might get more help in an Excel newsgroup. You could try: microsoft.public.excel.programming Quote: > Hello, me again. Thanks to all the people that responded to my last > question, it was very helpful. > I created a macro that works wonderfully in Excel. I would like to be > able to have this happen automatically when I open the file (or > workbook). How do I have the Onopen event call the macro -- I've > nosed around in the modules a bit and thought I found the workbook > open one, but it didn't work so I must have done something wrong. > Again, thanks very much for the help -- it is certainly appreciated! > alf > also reachable by
Tue, 19 Aug 2003 20:49:24 GMT

Idoneus Vale #3 / 4	How do I Create an On-Open Macro for Excel Workbook -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi alf, use: sub auto_open() ... endsub this should solve your problem regards, Idoneus Quote: > Hello, me again. Thanks to all the people that responded to my > last question, it was very helpful. > I created a macro that works wonderfully in Excel. I would like to > be able to have this happen automatically when I open the file (or > workbook). How do I have the Onopen event call the macro -- I've > nosed around in the modules a bit and thought I found the workbook > open one, but it didn't work so I must have done something wrong. > Again, thanks very much for the help -- it is certainly > appreciated! > alf > also reachable by -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBOqKCM5F+2bSMje5aEQJ41ACgip6FI5KBn91hVwR0hHyElAvGW7sAnjZm rmZXGmKXZDPWJoqENw3MphPp =cDGh -----END PGP SIGNATURE-----
Fri, 22 Aug 2003 01:58:17 GMT

alf #4 / 4	How do I Create an On-Open Macro for Excel Workbook Idoneus, thank you. Just got out of Hospital, and was finally able to complete project. Apologies for delay in thanking you. Alf Quote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 >Hi alf, >use: >sub auto_open() >... >endsub >this should solve your problem >regards, >Idoneus >> Hello, me again. Thanks to all the people that responded to my >> last question, it was very helpful. >> I created a macro that works wonderfully in Excel. I would like to >> be able to have this happen automatically when I open the file (or >> workbook). How do I have the Onopen event call the macro -- I've >> nosed around in the modules a bit and thought I found the workbook >> open one, but it didn't work so I must have done something wrong. >> Again, thanks very much for the help -- it is certainly >> appreciated! >> alf >> also reachable by >-----BEGIN PGP SIGNATURE----- >Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> >iQA/AwUBOqKCM5F+2bSMje5aEQJ41ACgip6FI5KBn91hVwR0hHyElAvGW7sAnjZm >rmZXGmKXZDPWJoqENw3MphPp >=cDGh >-----END PGP SIGNATURE-----
Fri, 12 Sep 2003 07:25:58 GMT

Page 1 of 1

[ 4 post ]