"Enable Macros" pop-up box on open of workbook

[ACG]

I have a workbook with a variety of macros. I would like to atuomatically "enable macros" on opening of the workbook from any one of the users (potentially 30 or more users so I don't want them to "disable" the macros). Is there a way that I can remove the pop-up box that comes up to "enable macros" or "disable macros" on opening the workbook?

Thank you!

Anita

 

[Juan Pablo González]

In one word, No.

One option would be to get a Digital Signature and sign your project with it, that way, even if the user has macro security set to High, your project will load.

If they have it set to Medium, they'll have the option to enable/disable macros.

 

[Guest]

Juan,

Thank you for your answer. I didn't think there would be an easy way to handle it.

Anita