You need to run code to display a message box or userform; the macro security
warning is designed to prevent code from running without authorizing it
first. Sorry.

"Jack_Feeman" wrote:

I have tried the suggestions mentioned but the MS Macro Security Warning
"always" displays first.

I want to display a message box to the user on open "before" the MS macro
warning displays to remind them to answer yes to the MS macro warning rather
than have them restart Excel because they forgot to click yes.

Any luck in beating MS to the punch here?

Thanks
Jack