Disable macro security for selected workbook
 

I am using Excel 2003. I know how to lower the macro security warning from
Tools, Option, etc. However, I do not want to turn this feature off for
every workbook.

I only want to turn it off for a specific workbook when ever the end user
opens it. Can this be done? Maybe with VBA? How?

TIA.

Jan

If you think about it, being able to lower macro security from a macro may
defeat the object.

You could sign the project and that could then be added to the trusted list
or you could install it as an add-in (*.xla). Neither way will fire the
warning

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Jan" wrote in message
...
I am using Excel 2003. I know how to lower the macro security warning from
Tools, Option, etc. However, I do not want to turn this feature off for
every workbook.

I only want to turn it off for a specific workbook when ever the end user
opens it. Can this be done? Maybe with VBA? How?

TIA.