MrExcel Publishing
Your One Stop for Excel Tips & Solutions

code to turn off macro dialog box when Excel is started

Posted by Henry Mejia on October 09, 2000 1:48 PM

Is there a way to turn off the diaolog box (enable/disable macros)which appears when an Excel workbook is opened using VB code and not going through the menu.

I am creating Excel workbooks via a Visual Basic program and would like to disable the box when I save the workbook.

Posted by Jim Knicely on October 10, 2000 4:45 AM

You can disable this dialog box under the Tools/Macro/Security menu. Select 'Low' for a security level ... however, be careful of all the macro viruses floating around ...

I tried recording it as a macro, to see what the code would be - but it doesn't record ... and no code is produce.

Posted by Ivan Moala on October 11, 2000 2:03 AM

You can however write to the registry via API functions
to disable the macros........obviously this is something that should be used with the right intent... if you want the code then email me......
I have written one that works for excel97 that writes
to the subkey that controls this.