LOL sorry, brain not funtioning properly when I wrote that obviously.

The point of putting the documents on the Intranet in the first place is to discourage staff from saving docs on their C drive and manipulating them. I know we can never stop this behaviour, but we want to do what we can to stop it, hence the userform, and the hyperlink.

So, no, the boss won't be encouranging staff to download the documents to enable the macros to execute.