View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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.