![]() |
Disabling Auto_Open in distributed worksheet
I am running an auto_open macro at night using the XP scheduler. The macro
is in an empty spreadsheet xyz_template.xls. It imports data from multiple sources and saves the loaded data each day with a unique name, say xyz_2345.xls. (The xyz_template.xls remains unchanged ready for use the next night). I then e-mail the xyz_2345.xls file to multiple recipients. Since the auto_open macro is embeddied in this spreadsheet and since all our PC's are set to Medium Security Level every recipient iis asked whether to activate macros when they open the spreadsheet. I do not want them to activate the macro and, in any case, it will fail on their machines. I would like them to not know anything about the macro as the worksheet already contains all the data they need Is there a way for me to automatically deactivate the auto_open macro in the loaded spreadsheet prior to distribution? Maybe some way of projecting Application.EnableEvents = False from the xyz_template.xls to xyz_2345.xls Thank you in anticipation of any responses |
Disabling Auto_Open in distributed worksheet
Hi, Chip Pearson has a whole host of great stuff on his site, you will find all you need at this link http://www.cpearson.com/excel/vbe.htm Regards, Simon. -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=552710 |
All times are GMT +1. The time now is 11:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com