Surpress security warning or automate responce

[smiler44]

I want to surpress the security warning about enabling macros when a workbook is opened.
For the code Application.DisplayAlerts = False the user has to clcik enable macros. I do not want the user to be able to click Diable Macros when they open the workbook.

How can I
1. Supress the warning message?
2. Automate/simulate a clcik on the enable macros button when the workbook is opened?

Smiler44

 

[smiler44]

looks as if the warning message can not be bypassed.
I'll find a work around.
Deleting the command buttons will still give the user the message box but no matter which option they pick they can not do any damage as the do get the the buttons to click.
I'll look to see if there is a way to delete all macros from the workbook and hopefully that will surpress the message. The macros are not required for the users that will be sent the workbook.
smiler44

 

[DanWall]

It's in the excel options of the software, and each machine will have different settings.
You can change it the excel security settings.