James,

Can't be done programmatically.

You have three options under Tools/Macro/Security

High - Macros will not be enabled and you won't be prompted
Medium - You'll be asked whether to enable or not
Low - You won't be prompted and macros will automatically be enabled.

Read the descriptions of each when you get to that dialog box.

John

James wrote:

anyone know what the line is that stops the "do you want
to enable or disable macros?" box popping up on opening
(and enables macros)?

thanks