ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling Auto_Open in distributed worksheet (https://www.excelbanter.com/excel-programming/364527-disabling-auto_open-distributed-worksheet.html)

DaveF[_3_]

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

Simon Lloyd[_786_]

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