Hi Michael,

I
read somewhere that you can digitally sign the macro and
the message box will not appear, how do I do this.


In the folder where Office lives, there is a file called selfcert.exe.
Run it and follow instructions.

Then open your Workbook and in the VBE select Tools, Digital Signature.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com