Hi all, is there a way of capturing either the User name or Machine name that the workbook is being opened on?, i would like to send a workbook to some people but do not want to allow them to open the workbook on any other machine than their own so if their machine is called Office1 then they can only open it on there else close the workbook, all the network users are narrowed to being able to log on on one machine only i do not want them taking the workbook home!, single machine users outside the company i would like them to only open the workbook on the machine that recieved the e-mail with the workbook in.

probably an impossible task..........but maybe just maybe one of you may have an angle on this!

Regards,
Simon