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

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