I take it that it is important to retain the macro warnings.

There are two ways to do away with them.
1) Change the setting so excel stops checking for macros altogether.
2) Get your macros secruity signed.