View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl Carl is offline
external usenet poster
 
Posts: 361
Default 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.