Its security violations as normal vba code wont be run in a web browser. You need to adjust your setting by perhaps adding the site to your trusted sites collection since this is an intrranet site it should be safe.