Disable macro security for selected workbook

J

Jan

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.
 
N

Nick Hodge

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
[email protected]
 
Top