Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed to set macro security in Excel to minimum
I have an Excel file that is started automatically by Task Scheduler. The
Excel file runs some macros upon opening. Sometimes the macro security level in Excel is set at medium so the auto-open macro must wait for the user to enable the macros before continuing. This defeats the whole purpose of the project. Is there any way to have the auto-open macro set the macro security to minimum first? (I doubt it because this would defeat the whole purpose of macro security settings but had to ask). Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed to set macro security in Excel to minimum
You can't do that I'm afraid Carl .... It rather defeats the purpose of
macro security :-) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed to set macro security in Excel to minimum
Sometimes the macro security level in Excel is set at medium
I'm wondering what is changing the security level. If you've got a User that's messing with settings, that's where you need to start. One other possibility is to create a Visual Basic program that contains all your macros (most macros will port directly into VB6 Classic with the addition of objects set to the application and file). Then open the VB exe with Scheduler and have that open the Excel file and do stuff. Ed "John" wrote in message ... You can't do that I'm afraid Carl .... It rather defeats the purpose of macro security :-) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro needed to set macro security in Excel to minimum
You might want to looking into using Selfcert.exe to certify your workbook
(3rd link). http://support.microsoft.com/default...;en-us;Q288985 XL2002: About Digital Signatures in Excel Workbooks http://support.microsoft.com/?KBID=206637 OFF2000: Overview of Digital Certificates (Q206637) http://support.microsoft.com/?KBID=217221 OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects (Q217221) An Overview: http://msdn.microsoft.com/library/de...tml/combat.asp Another reference: http://msdn.microsoft.com/library/en...vbaproject.asp should be applicable to xl2000 and later. -- Regards, Tom Ogilvy "Carl" wrote in message ... I have an Excel file that is started automatically by Task Scheduler. The Excel file runs some macros upon opening. Sometimes the macro security level in Excel is set at medium so the auto-open macro must wait for the user to enable the macros before continuing. This defeats the whole purpose of the project. Is there any way to have the auto-open macro set the macro security to minimum first? (I doubt it because this would defeat the whole purpose of macro security settings but had to ask). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro security in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Security | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Not able to KEEP Macro Security Level At Minimum | Excel Discussion (Misc queries) | |||
Excel XP XML macro security warning | Excel Programming |