Thanks again you chaps, but I don't quite see how your advice can help me.
Currently if I pass this workbook on to anyone else for their own use, and if they have a need for some people to receive automatic notifications, I have to give them the VB exe and some instructions as well as the workbook. Now to be honest it's not that much of a faff to do that, and everything does run just tickety-boo so things are fine and I have no big problem.

However, it would be much neater if, when the Workbook_Open event kicks in, I was able to identify if the book was being opened by an end user or if it has been scheduled by the task manager. This would allow me to have all of the logic inside of the workbook.
As previously stated Windows is generally left open under the default user.