Prevent users from emailing workbook

**VBA FTW** · 12-17-2012, 11:03 AM

Is there any way to block users from emailing a workbook to themselves??

**Ron Coderre** · 12-17-2012, 11:58 AM

Not really. What would stop them from just attaching it to an email? or sending it to an alternative email address?

**VBA FTW** · 12-17-2012, 12:25 PM

Well, that's what I'm trying to prevent. I want to find a way to prevent a workbook from leaving the office period. Whether it be through email, flash drive, external hard drive etc. Preventing emailing of a file was my first step in trying to figure it out, but I'm betting this is not possible

**6StringJazzer** · 12-17-2012, 12:43 PM

It's not possible to do it from within Excel. The only way to prevent specific file attachments via email is policies in the company email system. Preventing copying to external devices is even trickier, though I think the US DOD had it figured out a long time ago.

There might be some way to write a macro that would not permit the workbook to be opened if it is not in the office environment but macros are easily disabled.