Ok a much easier way that requires no code would be to go to
Tools--Macro--Security. Set the security to low. Doing this will
automatically open the document without a confirmation. Low security
should only be used if you are sure that the document is safe and you
can monitor who uses it. This should solve your problem. Let me know!

-Justin