I can't believe this code has been posted here, talk about opening the door.
It's not suitable for your needs anyway, you want the user to open your workbook and get no warning about the macro that is about to run; I'll bet you have used this code in your workbook, as a macro, which means Excel will see it and display the warning before it runs it. Open your workbook, let the code run then check your macro security level.
To use this code you need another mechanism for running it other than excel, and you need to instruct your users to use that mechanism to open your spreadsheet. (I am not going to tell you how to do that in an open discussion).
This opens you up to all sorts of risks, even if you are on a secured intranet you need to worry about viruses; users bring them in from home on floppies, usb pens, CD's, emails etc.
And of course, all the l337 h4cx0r5 now know how to get round the macro warning because this thread will appear in google soon enough.